QlikView vs Qlik Sense

Recently I decided to perform a technology bake-off by taking one data set and building a dashboard utilizing QlikView and Qlik Sense. For this exercise I chose MLB Free Agency data that uses a SPSS regression model to help determine a players value based on years of historical baseball data and statistics. Below are some…

Read More

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