topic Re: Showing last 12 months data. in QlikView

Showing last 12 months data.

kishorj1982 — Thu, 02 Nov 2017 09:03:48 GMT

Hi All,

PFA

Can you please suggest how to show last 12 months data

thanks

Re: Showing last 12 months data.

arvind_patil — Thu, 02 Nov 2017 09:18:57 GMT

Hi Kishor,

I think You require rolling 12 months data :

Please go thorough below thread.

12 month rolling data‌

max year rolling 12 months

Thanks,

Arvind Patil

Re: Showing last 12 months data.

Anonymous — Thu, 02 Nov 2017 13:36:53 GMT

use the function Today() --> Today() -12 and all this in a month function -- > month(Today() -12)

= {">=$(=Date(AddMonths(vMaxDate, -12), 'MMM-YYYY'))<=$(=Date(vMaxDate, 'MMM-YYYY'))"},

and vMaxDate = Tady()

another way more efficient and useful is to create in your script a calendar where you'll have for days, months, years, quarters and then use it as a dimension