topic Re: Date Button/Filter: Last 12 Months in QlikView

Date Button/Filter: Last 12 Months

Tue, 04 Aug 2015 15:38:19 GMT

I have many sheets which use a date field within charts. Similar to a list box to filter by year, I'd like to have an option for the user to select Last 12 Months instead of manually picking 365 days.

Is this possible? Is it better as a button? How would I write this expression? Basically it is if my date field is >= 365 days ago, show it if clicked or if deslected show all data.

Thanks in advance!

Re: Date Button/Filter: Last 12 Months

maximiliano_vel — Tue, 04 Aug 2015 15:56:06 GMT

From Recipes | QlikView CookBook - Rob Wunderlich

Recipes | Qlikview Cookbook

Regards

Re: Date Button/Filter: Last 12 Months

Kushal_Chawda — Tue, 04 Aug 2015 16:47:19 GMT

Create field monthyear using monthname(Date)

Create expression:

=sum({<year,month,monthyear={">=$(=addmonths(max(monthyear),-11))<=$(=addmonths(max(monthyear),0))"}>}Sales)

Re: Date Button/Filter: Last 12 Months

Tue, 04 Aug 2015 20:09:58 GMT

Thank you! This was perfect!