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.
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.
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 "*".