Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Uploads getting stuck in the virus scanner. We are investigating.
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