topic Re: if clause in a variable in QlikView

if clause in a variable

Anonymous — Wed, 03 Jan 2018 05:54:23 GMT

Howdy! In short, I want bring in a different month for the measure defined in my if statement in my variable.

my expression is the following Sum({<MonthNum={$(=(vMonth_adj))}>} $(cost_adjusted))/

my month variable vMonth_adjusted is defined as if(Measure= 'WSK var cost', Concat(DISTINCT [MonthNum], ',')+1, Concat(DISTINCT [MonthNum], ',') )

apparentl tihs expression does not work? I would appreciate your help.

(Meanwhile when vMonth is defined as =Concat(DISTINCT [MonthNum], ',') it works fine!)

Re: if clause in a variable

pradosh_thakur — Wed, 03 Jan 2018 11:07:35 GMT

may be

if(Measure= 'WSK var cost', Concat(DISTINCT [MonthNum] +1 , ','), Concat(DISTINCT [MonthNum], ',') )

Re: if clause in a variable

Anil_Babu_Samineni — Wed, 03 Jan 2018 11:45:00 GMT

Can you show image of this?

if(Measure= 'WSK var cost', Concat(DISTINCT [MonthNum], ','))

Re: if clause in a variable

marcus_sommer — Wed, 03 Jan 2018 12:53:41 GMT

This part: if(Measure= 'WSK var cost' within your variable won't be evaluated on row-level because it is part of an adhoc-variable which will be evaluated global before the chart is calculated and applied on each row. Quite probably there are more han one value for Measure available and without an aggregation on the field it will return NULL.

Further concat() will return a string if more than one MonthNum is available and adding with 1 will also return NULL. What is the aim for + 1?

- Marcus