topic Re: Getting previous month data in QlikView

Getting previous month data

Wed, 25 Nov 2020 16:16:04 GMT

Hi All

I having data like below

31-May

30-Apr

31-Mar

28-FEB

31-Jan

Here I need to show the bar chart based on previous month only by default. I dont have date wise data and having only month end level only

-Jai

Re: Getting previous month data

sunny_talwar — Fri, 16 Jun 2017 15:27:31 GMT

May be like this

Sum({<Date = {"$(=Date(Floor(MonthEnd(Max(Date), -1)), 'DD-MMM'))"}>}Measure)

Re: Getting previous month data

jwbadger3 — Sat, 17 Jun 2017 01:50:37 GMT

Sunny's expression should work but you should consider creating a variable and then referencing that variable in set analysis. That way you can re-use this in other charts or elsewhere in the app.

Another quick tip is to create a universal calendar so that you can look at previous month only (instead of a specific date) but that's not necessary.

To create a variable, I would do this in script as:

Set vLastMonth = Date(Floor(MonthEnd(Max(Date), -1)), 'DD-MMM');

Then in your expression you can simply reference this value.

Sum ( {<Date = {'$(vLastMonth)')}>} Measure)

Re: Getting previous month data

Anonymous — Mon, 19 Jun 2017 05:39:31 GMT

Perhaps using the Peek function to get the previous month