topic Re: Alternate State in QlikView

Alternate State

Thu, 05 Feb 2015 15:02:18 GMT

Hi,

I am using Alternate states to calculate Sum of a Field in two different charts with say AS1 and AS2 Alternate State applied

Eg.:

Dim1	Dim2	Exp-AS1
100	Abc	=20
101	Pqr	=31

Dim1	Dim2	Exp-AS2
100	Hij	=11
101	Mno	=04

Now, I need to calculate difference between the Expression in another Chart which is WHITHOUT alternate state;

Dim1	Exp
100	09
101	27

kindly help with any idea !

Thanks in advance !

Re: Alternate State

Anonymous — Thu, 05 Feb 2015 15:06:00 GMT

Within Set Analysis you can define which Alternate State an expression should use.

So create two expressions against the two States and subtract them

Re: Alternate State

Anonymous — Thu, 05 Feb 2015 15:07:34 GMT

Here the bit from the Help about it :

Comparing Alternate States

You can compare two states on the same object. For example, you can create a line chart to display both states of the data with the same axis by assigning a state in the expression using Set Analysis.

Example:

If you have defined the states Group1 and Group2, you can compare the average of field Adj.Close for the groups by showing these two expressions in a line chart:

Avg({[Group1]} [Adj.Close])

Avg({[Group2]} [Adj.Close])