Qlik Community

Qlik Sense Enterprise Documents

Documents for Qlik Sense related information.

Qlik Sense Basket Analysis


Qlik Sense Basket Analysis

Who here LOVES alternate states in QlikView?

A brief description (and the reason I wanted to explore the subject) is that Alternate States allow you to segment one or many dimensions in your data in to their own "state". I can easily compare something like sales of product A to sales of product B.

Well alternate states does not yet exist in Qlik Sense and basket analysis is hugely important for industries like Retail so they can analyze exactly what I described (sales by product, segment or region). Now QlikView did not always have Alternate States either so how did we accomplish the same type of analysis?

Here is what I came up with (I'm sure there is more than one way to accomplish this):

1. I created a "data island" so that I can break the connection between Basket A and B. A user can then select a value from Basket A and a different value in Basket B while still utilizing Green-White-Gray.

Sense Basket Analysis Model.jpg

2. Now that the user can select from Basket A and B we want to display them next to each other so I created a bar chart for side by side analysis. For the Basket A (left) side I just created a measurement based on my original data model. For the Basket B (right) side I used Set Analysis to apply the data island selections to my calculation.

Sense Basket Analysis.jpg

Basket B set analysis

I did identify one quirk when writing the set expression where not selecting any values could not calculate so I added some logic to handle the "NULL" selection as select ALL or "*".

Sum({<CategoryName={'$(=if(IsNull(CategoryName2)=0,CategoryName2,'*'))'},ProductName={'$(=if(IsNull(Product2)=0,Product2,'*'))'}>} Sales)

Version history
Revision #:
1 of 1
Last update:
‎07-24-2015 06:13 PM
Updated by: