Filtering Data

[Pomna]

Below is my set expression which gives me values for last month but I would like to create a filter that would enable me see data for other months too like last two months or last  three months. Thanks for your suggestions

Sum({$<[Work Date.autoCalendar.Year] = {'$(=year(today()))'}
,[Work Date.autoCalendar.Month] = {'$(=month(AddMonths(Today(),-1)))'}
,[IS.Activity Type] = {[Enhancing]}
,[Supported Location] =- {'04'}>}Hours)

[andoryuu · Accepted solution]

I'd recommend adding a variable to your app - let's call it vYearsBack. You set it to default to 1. Have a variable editing box that allows a user to enter number of years to go back. Then change your set analysis to this:
Sum({$<[Work Date.autoCalendar.Year] = {'$(=year(today()))'}
,[Work Date.autoCalendar.Month] = {'$(=month(AddMonths(Today(),$(vYearsBack)*-1)))'}
,[IS.Activity Type] = {[Enhancing]}
,[Supported Location] =- {'04'}>}Hours)

I have successfully tested this in Qlik Sense September 2019 Patch 2.

[Pomna]

Thank you so much andoryuu. It worked like magic

[Pomna]

One more issue if you please. If I want my variable editing box to show month names instead of numbers how do I go about it?  I would like the user to be able to select month name and year. Thank you

[andoryuu]

No problem - Just post it as a separate question and I can give details under that post (that way it'll be searchable by others).  I'll be able to detail that tomorrow (or someone may beat me to the punch!).