topic Re: How to find Previous Month Data in QlikView

How to find Previous Month Data

Fri, 19 Oct 2012 10:32:19 GMT

Please find the attached application,

Assumptions: suppose current month is April.

Problem: I need to write two expressions, First Expression will find the total amount of last month (i.e: March=1350 ) and the second expression will find the total of last three months (i.e:Feb=990,+ Mar=1350, + April=950; Total of last three months= 3290,Note : Last three months includes current month as well

Regards

Zain.

Re: How to find Previous Month Data

sivarajs — Fri, 19 Oct 2012 12:00:20 GMT

PFA

Re: How to find Previous Month Data

Fri, 19 Oct 2012 12:15:53 GMT

thanks for the solution,

Last three months still not working well if you notice, the second expression for last three months will give last four month's data .

Re: How to find Previous Month Data

sivarajs — Fri, 19 Oct 2012 12:28:16 GMT

Check the above qvw file again,but its better to use date field

Re: How to find Previous Month Data

Fri, 19 Oct 2012 12:35:15 GMT

Thanks for the advice & solution .

Re: How to find Previous Month Data

Anonymous — Fri, 19 Oct 2012 12:54:30 GMT

Hi Zain,

First, create a new field MONTHNUM containing month in numeric value with applymap.

Then, use variables to get appropriate month value:

_currentMonth=MONTHNUM

_previousMonth=_currentMonth-1

_previous3Month=currentMonth-3

Create expressions using thoses variables:

For last month:

Sum({$<MONTHNUM={'$(_previousMonth)'}>}AMOUNT)

For last 3 months:

Sum({$<MONTHNUM={'>=$(_previous3Month)<=$(_currentMonth)'}>}AMOUNT)

Hope it's usefull

Regards

Vincent