Filter by Value/Toggle Button

[BrianDH]

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

[hallquist_nate]

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

[dwforest · Accepted solution]

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