With this post I would like to challenge the people reading this and using Qlik Sense a bit more frequently. The animated gif (analysis demo) reveals some of the concepts and solutions that need to be solved by you in this challenge:

1. Dimension values can be switched using a variable drop down
2. A scatter chart helps to zoom-in on customer/products/industries (chosen in the drop down) for the variance they are causing
3. A treemap is used to showcase more details of your selection in the scatterchart. There are only positive values in the treemap. Colors indicate what kind of difference items are causing

(Click on the image to see the animation)

Challenge preview demo

After you studied this a few times 😉 you should be able to understand what the challenge means in terms of how to solve this puzzle. To get you started I posted an empty app with this post. All data, dimensions and measures are available. So you don’t need to do anything on that part, thank me later 😉

In the next few paragraphs I will take you over some more details of what you should achieve with this:

The variable switch
First, on the left top of the screen you see a variable drop-down. The extension for this can be found at branch.qlik.com. Have a look at the preview above to see what values (Hint: dimension fields) need to go in.

The scatter chart
– The scatter chart takes a calculated dimension over the revenue variance (2012 versus 2013) and is divided into buckets of 100K
– The measures for this chart are ‘Revenue’ and ‘Gross Margin %’
– The colors for the bubbles are calculated for the variance buckets. Red a negative difference and green for positive differences
– The bubble size is defined by the measure ‘Gross Margin %’

Note: The bubbles contain the customers (or dimension chosen by the variable switch) that belong to that bucket.

The treemap
– The treemap contains whatever dimension is chosen in the variable dropdown
– The values and size of the blocks do represent all differences, positive or negative. Color in this one indicates if the value is positive (green) or negative (red)

The challenge
If you choose to participate and send me a finished solution for this puzzle I will also share with you the app I have in my archive.

Have fun, challenge yourself and feel free to ask questions in the comments below.

Happy designing!