Dynamic Bookmark filter with Max & Min Date

[christoph_suessmann]

Hi all,

I have the need to dynamically select a date filter when a dashboard was opened to show always the last 14 days. When loading the data I create the variables vMinDate = Today()-14 and vMaxDate = Today().

When I want to use these variables in the filter I always get all dates, I use this expression in the filterpane:

DATE={"=DATE>='$(vMinDate)'"},{"=DATE='$(vMaxDate)'"}

which gives me all the dates.

Using:

DATE={"=DATE>='$(vMinDate)'"} works perfectly fine.

Is there a way to perform my needs in Qlik Sense?

Best regards

Christoph