Using Month as a Value

Mon, 19 Mar 2012 08:54:35 GMT

Hi Guys,

I am sure this is a pretty easy question but for the life of me I can't get this right. I have an inline table with Period (October, November, December etc) and a corresponding field with the values (1, 2, 3 etc). I now have a Pivot chart with a 2 dimensions, 1 being the vertical and Period being the horizontal. So running horizontally I have (October, November, December etc).

I have an input box where a user would select a month like February. If this month is selected any period before this is excluded from the dimension. So for example

If(Period<=vCurrentMonth,Period)

Now i assumed because of my PeriodValue in my Inline Period Table it would correctly exclude all previous Periods, but instead its not. How would I get this right. Hope my explaination makes sense. I have read up on the dual function, but this, or the way i'm doing it is not correcting the problem

Thanking you smart folks in advance

Cheers,

Byron

Using Month as a Value

CELAMBARASAN — Mon, 19 Mar 2012 10:35:25 GMT

Hi,

Have you created month field as dual field.

Example

Load

Dual(MonthString,MonthNum) as Month

Inline

[MonthString,MonthNum

Jan,1

Feb,2

Mar,3

............];

Celambarasan

topic Using Month as a Value in QlikView

Using Month as a Value

Using Month as a Value