Button: Using as a filter pane

[george55]

Hi all,

Have a filter pane which worked fine with this expression: 

=If(FieldX > FirstWorkDate($(=Max(Floor(FieldX))), 5, $(Holidays)))

Don't know the syntax or how to put it in an extention like "Button for navigation". Tried with the action "Set variable value". Or do I use the wrong Action or the wrong Extension?

Thanks.

[UserID2626]

what is your requirement in "Button for navigation"?

[george55]

To have the same behaviour as in a filter pane. The formula you could see in my first post. FieldX is a date-dimension. So the goal is to constrain to specific dates.

[UserID2626]

Button navigation is to navigate from sheet to like one page to another page.

ur requirement looks like displaying value. 

U can try a condition like below in Button Layout->Unable condition

=if(MAx(Date)=Max({1}Date),True(),False())

https://help.qlik.com/en-US/sense/November2019/Subsystems/Hub/Content/Sense_Hub/Visualizations/Dashb...

[george55]

thats the reason why I asked if I am using the right extension. thanks for your answer, but this is only a layout action. Need to filter.

Btw, it is possible to do some filtering in the button for navigation extension. But don't know the limitations and if it is posible with my formula.

[george55]

Maybe I have to use the action "Select mutliple values in a field" and use something leant  see below? In the end there are multiple values...

='>'& FirstWorkDate($(=Max(Floor(FieldX ))), 5, $(Holiday))

[george55 · Accepted solution]

It worked! The solution was to initiate and end with "'" and using a concat

="'" &
Concat(Distinct
FirstWorkDate($(=Max(Floor(FieldX ))), 5, $(Holiday))
, ';')
& "'"

[QSSR]

We are trying to use the button for filter pane as well.  The logic is [EnrollmentDate] >= 1/10/2019 and <= 2/1/2019, and [StudentID] is blank .  What is the syntax for the field defined expression (why concat is needed) ? Is there any documentation available?

Thanks,

[george55]

Had the same issue, couldn't find meaningful documentation, even it is an official Qlik extension.

In the end, did not use the button for this purpose anymore. The reason is, even it is working fine, it is 10 times slower then the filter pane. The processing of such expressions may work differently then in a filter pane. With the current Qlik version I recommend against it.