Qlik Community

Ask a Question

New to Qlik Sense

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

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
philipp_des
Partner
Partner

climber selection bar extension: initial selection with wildcards

Hi,

I need to filter the data by some pattern. E.g. path="Top>>Middle>>Sub" and I need all entries where the executionpath contains "Middle". Any ideas what the correct expression for this is?

The docu only mentions expression or list:
Initial selection - Any field/variable can be set for an initial selection using an expression or comma separated list.
Alt text

Labels (2)
1 Reply
michael_nordstr
Partner
Partner

Hi,

The best approach would be to create a separate field in the script for the path so you only have to select in one field rather than do a search across potentially large volumes of data. Then use that new field in the selection bar to make initial selections. You can of also hide the field if you do not want it to be visible in the selection bar.

(In the script you could for example use wildmatch() to get the strings you are looking for and create the new field.)