topic Variable with Previous Month in QlikView

Variable with Previous Month

Anonymous — Tue, 01 Mar 2016 14:25:25 GMT

Hi All

I was trying to set a variable in my script

LET vPreviousMonth = (Month(TODAY())-1);

LET vPreviousMonth1 = Month(TODAY());

but

vPreviousMonth1 = Mar

I want it to say Feb so i try vPreviousMonth but this comes as 2....any ideas how i can change it to say Feb and not 2?

Thanks

sunny_talwar — Tue, 01 Mar 2016 14:27:47 GMT

Try this:

LET vPreviousMonth = Month(AddMonths(Today(), -1));

Anonymous — Tue, 01 Mar 2016 14:29:54 GMT

Thanks...as always Sunny...You're a Star!

sunny_talwar — Tue, 01 Mar 2016 14:32:18 GMT

I am glad you think so .

Anonymous — Tue, 01 Mar 2016 14:46:25 GMT

I think you deserve it, The Amount of times you answered my questions and soooo Quickly