Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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?

 

ALL HELP WOULD BE APPRECIATED! 

Labels (2)
0 Replies