topic Re: Month convert to Number in QlikView

Month convert to Number

Tue, 17 Mar 2015 05:49:43 GMT

Hi All,

I have a formula which is like

sum

({$<month={num(month(addmonths(today(),-3,1)),'00')}, BUCKET5={"A.*"}>}CURROSSGD)

I got a variable called month. Another variable is BUCKET5. I want to sum up the CURROSSGD.

I would like to get the month value equal to 3 month ago from current month (such as Dec 2014 as today is 17/03/2015.

But anything wrong with the formula above? Why the num is black? Qlikview keeps telling me I got errors.

Tue, 17 Mar 2015 05:58:03 GMT

Try now

=sum({$<month={"$(=num(month(addmonths(today(),-3,1)),'#,##0'))"}, BUCKET5={"A.*"}>}CURROSSGD)

Tue, 17 Mar 2015 06:05:27 GMT

Try this

=sum({$<month={"$(=num(month(addmonths(today(),-3))))"}, BUCKET5={"A.*"}>}CURROSSGD)

mukesh24 — Tue, 17 Mar 2015 07:23:05 GMT

create variable as

vMonthNum = num(month(addmonths(today(),-3)))

Use above variable in expression

({<month = {"$(vMonthNum)"},BUCKET5 = {"A*"}>} CURROSSGD)

jagan — Tue, 17 Mar 2015 07:48:17 GMT

Hi,

Try like this

Month(AddMonths(Today(), -3))

Regards,

Jagan.

vvvvvvizard — Tue, 17 Mar 2015 07:57:49 GMT

You cant use the Months variable if it contains Jan , Feb , Mar , April ect as Dec -3 is not march.

You should rather use the another variable which contains Month and year together Dec-14 , Jan15 , Feb-15.

Now you can say Month(AddMonths(Period, -3) )