Dynamic Date Filtering for multiple Dates columns from multiple tables

robertbrooks — Mon, 20 Dec 2021 21:32:42 GMT

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!

Re: Dynamic Date Filtering for multiple Dates columns from multiple tables

jonathandienst — Wed, 04 Mar 2020 06:34:01 GMT

This may provide some help:

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

topic Re: Dynamic Date Filtering for multiple Dates columns from multiple tables in App Development

Dynamic Date Filtering for multiple Dates columns from multiple tables

Re: Dynamic Date Filtering for multiple Dates columns from multiple tables