topic Help with an Expression Label in QlikView

Help with an Expression Label

Anonymous — Thu, 22 Oct 2015 12:16:50 GMT

Hi Guys,

I have the field DAY_RATE brought in via an SQL Load but I want to know is there anyway where I can write an Expression for the DAY_RATE label that:

if END PERIOD (A normal date DD/MM/YYYY) is equal to the period APRIL-OCTOBER it says SUMMER_DAY_RATE or if the END PERIOD is equal to NOVEMBER-MARCH it says WINTER_DAY_RATE.

Regards

Re: Help with an Expression Label

sunny_talwar — Thu, 22 Oct 2015 12:53:45 GMT

May be this:

LOAD *,

If(Num(Month([END PERIOD]) >= 4 and Month([END PERIOD] <= 10, 'SUMMER_DAY_RATE', 'WINTER_DAY_RATE')

Re: Help with an Expression Label

Anonymous — Thu, 22 Oct 2015 13:49:20 GMT

Hi Sunny,

How would this work as an expression in the label tab?

If(Num(Month([END PERIOD]) >= 4 and Month([END PERIOD] <= 10, 'SUMMER_DAY_RATE', 'WINTER_DAY_RATE')

The above alone doesn't seem to be picking it up.