Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Filter by Value/Toggle Button

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

 

 

Labels (4)
1 Solution

Accepted Solutions
Highlighted
Specialist II
Specialist II

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

View solution in original post

2 Replies
Highlighted
Partner
Partner

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

Highlighted
Specialist II
Specialist II

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

View solution in original post