Qlik Community

Qlik Sense App Development

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

Highlighted
BrianDH
Contributor 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

 

 

1 Solution

Accepted Solutions
dwforest
Valued Contributor II

Re: Filter by Value/Toggle Button

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
Partner
Partner

Re: Filter by Value/Toggle Button

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
Valued Contributor II

Re: Filter by Value/Toggle Button

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