Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
george55
Partner
Partner

Button: Using as a filter pane

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.

Labels (1)
  • SaaS

1 Solution

Accepted Solutions
george55
Partner
Partner
Author

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

 

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

 

View solution in original post

8 Replies
UserID2626
Creator II
Creator II

what is your requirement in "Button for navigation"?

george55
Partner
Partner
Author

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
Creator II
Creator II

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())

Image.JPG

 

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

george55
Partner
Partner
Author

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

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

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

 

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

 

QSSR
Partner
Partner

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

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.