Calender Expressions

bharath28 — Tue, 15 Oct 2013 08:47:34 GMT

Hi Experts,

The below expressions carries the column from master calendar. So I expect these expressions to pick the values present in

the master calendar table. However when I say =max(Year)-5 it gives the output as 1998, whereas I expect the output to be 0 as 1998 is not present in the master calendar table.

Could you please guide me where I am doing wrong.

=Max(CalYear)-15

My other query is the below expression gives output as Jan, but I expect it to give Oct, which is the latest month in master

calendar.

=month(max(CalMonth))

Please guide me with the correct expressions.

Regards,

Bharath

Re: Calender Expressions

swuehl — Tue, 15 Oct 2013 09:04:02 GMT

Bharat,

your max(Year) is probably 2003, and this is the only information retrieved from your master calendar in your first expression. Then you subtract 5, which is just executed as a mathematical operation

=2003-5 = 1998

There will be no check if 1998 is part of your year data.

=month(max(CalMonth))

returns Jan, e.g. if CalMonth is already in a format with a numerical representation 1-12 for the months.

So just try

=max(CalMonth)

What do you get?

topic Calender Expressions in QlikView

Calender Expressions

Re: Calender Expressions