Sheet Actions for Date filtering

[J_Uri]

Hi.

I've been trying to use the Sheet actions to filter a set of dashboards with the max(date) of a date field.

Sheet actions work perfectly fine with any other field but not with this date field.

I've tried using several formats, variables and changing the value to a string to compare to the field, however it never selects a value and never applies the filter.

Any idea how to solve this? 

I cannot use the "Allways one selected value" under field settings since we need to apply to only a few pages instead of the whole dashboard.

[dplr-rn · Accepted solution]

that seems odd. 

i tried and got same result. will keep checking i would ask you to raise to qlik support as well.

as a work around 2 options

1- create a flag for max date in your master calendar. and set that as Y in sheet

2- create a dynamic bookmark something like  below and set the action to apply bookmark

=OrderDate=Max(total OrderDate)

refer https://www.youtube.com/watch?v=tFyqOigqnUw

[J_Uri]

That did the trick.

Cheers mate, thanks a lot ^^

[KirillS]

Try to use:

=Num(<your date>)

it works for me...