topic Re: Filter by Value/Toggle Button in App Development

Filter by Value/Toggle Button

BrianDH — Sat, 16 Nov 2024 04:11:42 GMT

I am trying to give my user a way to filter the Sheet with a single button click. The Sheet opens showing all relative data but when the button is "Clicked" she wants the data filtered to just yesterday's data.

I am using one Sheet Navigation/Action button.

Action before navigation = True

First Action: Set Variable Value

Variable Name: vDate

Value: =Date(Today()-1)

I know from seeing examples I'll need a global VAR, but i am not sure what/how to use it

Variable: set vBtnValue = ;

Any help?

Thanks

Re: Filter by Value/Toggle Button

hallquist_nate — Wed, 06 Nov 2019 17:50:32 GMT

One way that I used to accomplish something like this is by using a Calendar table, and build a Flag for "Today". I would add a line in the calendar script that was something like this:

If(Date=Date(Today()), 1,0) as Today_Flag,

Then, I would build a trigger that Selects in the field Today_Flag and the value to select is 1.

See if that approach inspires you and let us know.

Nate

Re: Filter by Value/Toggle Button

dwforest — Wed, 06 Nov 2019 20:12:37 GMT

You need to create vDate in your variables so it can be set

Dual nature of dates (number, string)... It's been my experience with the Action button, dates only work with the numeric values (this may have changed with Qlik's version); regardless try Date#(Today()-1)

Another workaround would be to create a dynamic Bookmark = Date(Today()-1) and use the Action button to apply it