Showing Top x Values in a Pivot Table

One of the benefits of utilizing a straight table over a pivot table is the ability to limit the dimension values. With a straight table it’s quite easy, simply click on the Dimension Limits tab, under the Limits section, check the Restrict which values are displayed using the first expression check box. Select the show…

Read More

Qlikview – Creating a Heat Map Using “ColorMix”

Overview The colormix in Qlikview is a function that allows for different colors to be used in lieu of the default color scheme. As it states, it mixes colors depending on the minimum limit and maximum limit of an expression. There are several ways to create heat maps, but this should help with creating simplified…

Read More

QlikView: Custom Pop-up Labels

Let’s say I have a grouped chart with two expressions, Sales and Costs. I like the look of this chart, but there’s more information that can be provided to tell a better story, such as Margin and Margin %. So how can I add the additional information without altering the look of my chart? Custom…

Read More

Qlikview – Copying Objects and Expressions

Copying an Object Often time’s objects within a qlikview application are either reused or reused with minor changes, in other qlikview applications. This can be a time consuming process to recreate several of these objects. This can be done much faster. Simply, copy the existing object and make the necessary changes. You can copy sheet and chart…

Read More