Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
KayPong
Contributor II
Contributor II

Auto select another value when user selected one value in the filter pane

I have a  chart that requires to auto select another value when user selected one value in the filter pane. For example when I select July 2016 in the Date field, I would like that particular chart to treat it as both July 2016 and June 2016 are selected even though the user has only selected July 2016. May I know how should I modify the expression for this chart as shown below:

count({< [Status] = {"Live"},
                   [Termination Date] = {"$(= (Addmonths(Max([Report Date]),-1))"},
                   [Report Date] = {"$(= Addmonths(Max([Report Date]), -1))"}>} [Record Count])

Labels (2)
1 Reply
kashyap311996101

Hi 

Please find the file in below attachment

 

Hope it helps

Thanks

Thanks and Regards
Kashyap.R