topic Re: Expression understanding in QlikView

Expression understanding

Tue, 22 Sep 2015 09:52:31 GMT

Hi All,

Alternate sets G , B defined in a dash board.

One Bar Chart defined with dimensions A -->This is field item and ValueList('G','B') -->This is Calculated dimension where G , B are not field items.

Expression is as follows.

if(ValueList('G','B') = 'G',Avg({G}C),if(ValueList('G','B') = 'B',Avg({B}C))) ---> Here C is field item.

I would like to know what is happening with above expression.

Could anybody help on this?

Thanks.

Re: Expression understanding

lironbaram — Tue, 22 Sep 2015 09:56:00 GMT

by using the value list

in one expression

you use to different sets of data

G,B are alternate states which mean are two different set of the data the selection on each set doesn't effect the other

Re: Expression understanding

sunny_talwar — Tue, 22 Sep 2015 10:00:41 GMT

This expression seems to be comparing the Avg(C) based on different selections in two states. Have you tried to build the scenario to see what it is doing? I think the best way to understand what an expression is doing it to make a small application and see what happens when you make selections.

Re: Expression understanding

Wed, 23 Sep 2015 09:44:42 GMT

Thank you all