Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

aboumejjane
Contributor

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

Tags (2)
3 Replies
sushil353
Honored Contributor II

Re: not Larger than current date in Set analysis

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

HTH

Sushil

aboumejjane
Contributor

Re: not Larger than current date in Set analysis

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

sushil353
Honored Contributor II

Re: not Larger than current date in Set analysis

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

Community Browser