topic Re: Current Month Vs Previous Month in QlikView

Current Month Vs Previous Month

vardhancse — Tue, 01 Dec 2015 14:00:20 GMT

Hi,

Created 2 variables:

vCurrentmonth=month(DateFull)

vPreviousmonth= Month(AddMonths(DateFull,-1))

Trying to build one expression:

Sum({<MonthName={'=$(vCurrentmonth)'}>}Actual) Now the value was coming correctly for the current month.

but when given previous month variable the value was same as current month:

Sum({<MonthName={'=$(vPreiousmonth)'}>}Actual)

can please do the needful.

Re: Current Month Vs Previous Month

thakkarrahul01 — Tue, 01 Dec 2015 14:10:44 GMT

Logically, it looks correct. can you please add data and sample qvw file.

Re: Current Month Vs Previous Month

miguelbraga — Tue, 01 Dec 2015 14:45:37 GMT

First of all your second expression is wrong (bad typing), it should be something like this:

=Sum({<MonthName={'=$(vPreviousmonth)'}>}Actual)

Then previous month needs to calculate the year, so that when you have for example a current date of 31/01/2015, the previous month should be 12 (December) from the previous year 2014.

Re: Current Month Vs Previous Month

sunny_talwar — Tue, 01 Dec 2015 14:50:54 GMT

Is MonthName function just Month or does it include year information as well? May be be if you can share some data, it would be much more faster and easier to help

Re: Current Month Vs Previous Month

miguelbraga — Tue, 01 Dec 2015 14:51:50 GMT

You'll need to add something like this:

vPreviousYearMonth = {$(=Year(addmonths(max(Data),-1)))}

vPreviousmonth = Month(AddMonths(DateFull,-1))

=Sum({$<Year = {'=$(vPreviousYearMonth )'}, MonthName = {'=$(vPreviousmonth)'}>} Actual)

I think, this way you'll get what you want