Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

Dynamic Date Filtering for multiple Dates columns from multiple tables

Hello Everyone,

 

I am currently working in the latest version of Qlik Sense Enterprise and am developing an app (dashboard) that contains 6 sheets that are clickable via buttons on the page. 

 

There are 4 tables that each have different dates (disposition date, application date, due date, case create date)that are used to filter each specific sheet. I need to create a dynamic filter that will display the last 6 months for each sheet depending on which sheet is currently selected. 

 

I have tried creating a flag that will show the last 6 months but when i click the filter for the month on the sheet, the last flag filter doesn't clear. I have also tried using master calendars and auto calendar for monthsago to no luck. 

 

Does anyone have any recommendations on how to create a dynamic bookmark or filter for each sheet based on the date from the table that is used?

 

Any help is much appreciated as I have been banging my head on this for weeks!

 

 

Labels (2)
1 Reply
Highlighted

This may provide some help:

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

 

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein