topic Re: Sheet Actions for Date filtering in App Development

Sheet Actions for Date filtering

J_Uri — Sat, 16 Nov 2024 17:54:30 GMT

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.

Re: Sheet Actions for Date filtering

dplr-rn — Wed, 28 Oct 2020 21:09:11 GMT

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

Re: Sheet Actions for Date filtering

J_Uri — Thu, 29 Oct 2020 08:12:11 GMT

That did the trick.

Cheers mate, thanks a lot ^^

Re: Sheet Actions for Date filtering

KirillS — Tue, 17 Jan 2023 03:44:53 GMT

Try to use:

=Num(<your date>)

it works for me...