topic Set Analysis and Variables in QlikView

Set Analysis and Variables

Wed, 04 Mar 2015 09:12:19 GMT

Hi All,

I Created a variable call vCdate

let vCdate=date(now()-1, 'YYYY-MM-DD');

i then have this set expression in my chart

sum({$<DTE=$(vCdate)>} Calls_off)

It returns 0, when i know the value is close to 50K

what am i doing wrong?

thanks

tresB — Wed, 04 Mar 2015 09:16:07 GMT

Try like:

let vCdate=date(Today()-1, 'YYYY-MM-DD');

sum({$<DTE={'$(vCdate)'}>} Calls_off)

Wed, 04 Mar 2015 09:17:53 GMT

Hi Stephen,

Please change the expression to

sum({$<DTE={$(vCdate)}>} Calls_off)

Regards,

Faisal

Wed, 04 Mar 2015 11:05:11 GMT

Ok so now i have the next part of this...

On month Level, so again i have created a variable

let vCmonth=if(date(today()-1)=1,month(AddMonths(today()-1, -1)),month(today()-1));

and the set expression is:

sum({$<month(DTE)=$(vCmonth)>} Calls_off)