topic not Larger than current date in Set analysis in QlikView

not Larger than current date in Set analysis

Anonymous — Wed, 05 Jun 2013 15:58:46 GMT

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

sushil353 — Wed, 05 Jun 2013 16:04:28 GMT

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

HTH

Sushil

Anonymous — Wed, 05 Jun 2013 16:22:14 GMT

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

sushil353 — Wed, 05 Jun 2013 16:35:31 GMT

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