Show comparison charts (dynamic set analyses)

[#1]

Hi all,

I am trying to do the following which seems to be tricky and I need your help.

I want to select an individual or a group of people and lock them as group a
Then I want to select an individual or a group of people and lock them as group b
Then I want to show comparison charts with expressions showing lines for each group. this will require set analysis on the selected group each time, like sum(sales) for that group of people.

My idea was to save the selections for group A and B in two variables like groupA and groupB. Then use the variables in each set analysis. The set analysis bit seems to work but I can't really use the variables the way I want to. All being saved in there is something like COLUMN NAME: xxx, xxxx, xxx if for example I had stored three names.

Any ideas?

thanks

[swuehl · Accepted solution]

If you are using QV11 and up, you can use alternate states for comparative analysis.

There is a demo in What's New in QV11 demo application you can install with the sample apps or download from demo.qlik.com.

[Clever_Anjos]

If you´re using Versio 11, use Alternate States, your requiriment is the 'classical' case for AS

[Clever_Anjos]

Check this, is in Portuguese, but I think you can follow

[#5]

Thanks, this is what I needed. I have a problem with showing the data correctly though. I have a chart with two expressions, the first one is bars that sum sales for group A and the second one is the same for group B (thats the comparison)

The problem is that group B always overlaps group A so usually I only see group B bars (unless there is specifically a bar in group A that is not contained in group B so I ll see it.) Wherever else just see the group b bars, instead of the same bars next to each other (since its an overlap).

Any ideas?