Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis and Variables

   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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

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

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

View solution in original post

4 Replies
tresesco
MVP
MVP

Try like:

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

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

View solution in original post

Not applicable
Author

Hi Stephen,

Please change the expression to

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


Regards,


Faisal

Not applicable
Author

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)

again it is failing, when you correct me, could you explain what i am doing wrong as this is getting frustrating

Not applicable
Author

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)

again it is failing, when you correct me, could you explain what i am doing wrong as this is getting frustrating