topic Show comparison charts (dynamic set analyses) in QlikView

Show comparison charts (dynamic set analyses)

Mon, 18 Nov 2013 15:49:55 GMT

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

Re: Show comparison charts (dynamic set analyses)

swuehl — Mon, 18 Nov 2013 15:53:40 GMT

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.

Re: Show comparison charts (dynamic set analyses)

Clever_Anjos — Mon, 18 Nov 2013 15:53:50 GMT

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

Re: Re: Show comparison charts (dynamic set analyses)

Clever_Anjos — Mon, 18 Nov 2013 15:55:19 GMT

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

Re: Show comparison charts (dynamic set analyses)

Tue, 19 Nov 2013 11:44:55 GMT

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?