topic Controlling expression in chart by user selection in QlikView

Controlling expression in chart by user selection

Wed, 28 Aug 2013 13:21:56 GMT

Hi,

I have a chart which is kinked to periods listbox selections: year, month, day

There is a Sum expression which should be calculated differenly in case a day or a month is selected.

For example, if a day is selected then sum(X).

For Month, it should be Sum(X+Y).

How can I distinguish between the selections?

Thanks in advance!

Wed, 28 Aug 2013 13:35:10 GMT

Use the method getSelectedCount(Field) to know hhow many rows of a field are selected. For your case, your can do:

if(getSelectedCount(Year)=0, sum(X), if(getSelectedCount(Month)=0, sum(X+Y))

Wed, 28 Aug 2013 13:38:53 GMT

Hi,

You can create an expression for each Sum expression and activate the option conditionnal :

For example the condition GetFieldSelections(day) = 1 is true when one and only one day is selected.

Hope it helps.

Regards,

Nicolas

CELAMBARASAN — Wed, 28 Aug 2013 13:42:17 GMT

Try with this

if(getselectedcount(Day)>0, Sum(X), Sum(X+Y))

Anonymous — Wed, 28 Aug 2013 13:44:39 GMT

Hi brain,

i have one doubt like if both are selected what you needed.

Thanks

Wed, 28 Aug 2013 16:21:39 GMT

Hi All,

Actually all answers were very helpful, but I liked the tip with the Conditional

Thanks!