Skip to main content
Applications are open for the 2024 Qlik Luminary Program. Apply by December 15 here.
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Last 6 Month Expression Filter on Button clik

Hello All,


I am trying to create a button that will be used on each of the 6 sheets I have on my application. I am trying to set the action of the button so that when clicked, it will select the Last 6 Months from a specific date field. 

For example: I have a date - Disposition Date - and when I click the button labeled "Default Value Selection" it will select the last 6 months from Disposition Date. Additionally, if there is a way to dynamically select 6 months from Disposition Date when there are months in the future but I only want to select current month through past 5 months.

How can I dynamically set an expression to select the last 6 months of the newest month is always current month or how to set dynamic expression where there are future months?



Labels (2)
0 Replies