Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

not Larger than current date in Set analysis

Hi Guys,

I have sales budget for a whole year. I would like to display the budget until the current month instead of a whole year.

I created a variable vCurrentMonth: =num(Max(month(Today())),00)

I used that variable to create the following expression:

=sum({<Month={"<$(vCurrentMonth)"}>} Budget).

I noticed that the budget sums everything till may. Which is good! However, when I selected jan., feb. march it ignores my selection.

What am I doing wrong?

Regards,

Sam

3 Replies
sushil353
Master II
Master II

Instead of Today() use your date field to create the variable.

HTH

Sushil

Anonymous
Not applicable
Author

I can't since my date field is till december 2013.

sushil353
Master II
Master II

do one thing:

1. create a text box and put your variable to see the value: =vCurrentMonth

now try to select the jab,feb in your fields..

the value in text box will not change because your slection not at all related to your dataset..

Try to get some other way to get the variable value..

HTH

Sushil