topic Re: Set Analysis Help in QlikView

Set Analysis Help

Tue, 25 Feb 2014 10:27:39 GMT

hi All,

i'm need your help please.

how to transform this request in Set Analysis :

if(IsNull(Cal_DAY),SUM(D1_D7)/sum(REG),if(Now()>Cal_DAY+8,SUM(D1_D7)/sum(REG)))

Thanks

dirk_konings — Tue, 25 Feb 2014 10:32:31 GMT

You can't do a nested if within SetAnalysis. Checking on NULL is also not possible via SetAnalysis.

SetAnalysis is for making 'Selections' in your expression, not testing a value.

Dirk

Tue, 25 Feb 2014 10:39:41 GMT

but i can use Cal_day={''} to define a null value

dirk_konings — Tue, 25 Feb 2014 10:43:46 GMT

no, but you could create an extra field in script which has a value 'X' when isnull(Cal_day)

This new field could be checked with SetAnalysis

er_mohit — Tue, 25 Feb 2014 10:46:01 GMT

Try this

if(IsNull(Cal_DAY),SUM(D1_D7)/sum(REG),if(Now()>Cal_DAY+8,SUM(D1_D7)/sum(REG)))

if(IsNull(Cal_DAY),sum({<Cal_DAY={" "}>}D1_D7)/sum(REG),

if(Day(today())>Cal_DAY+8,SUM(D1_D7)/sum(REG)))

Tue, 25 Feb 2014 10:46:32 GMT

ok i'll change my field to 'X' when Cal_day IsNull, and then how to write it in Set Analysis ?

it seems that Now() doesnt work

Tue, 25 Feb 2014 10:50:54 GMT

you expression works, but still using IF.

the IF statement seems to refresh my report every 5 seconds, which complicates the use of the chart.

dirk_konings — Tue, 25 Feb 2014 10:54:45 GMT

You better use Today() because now is the current system timestamp.

Dirk

Tue, 25 Feb 2014 10:56:09 GMT

right !

Tue, 25 Feb 2014 13:07:55 GMT