Qlik Community

App Development

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

Don't miss the upcoming Q&A with Qlik session on Qlik Application Automation on November 16th! REGISTER NOW
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

This may provide some help:



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