Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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