Discussion board where members can get started with Qlik Sense.
I have a field which is a multi-pick list so when I apply a filter it looks like;
I would like to group the filters so all organisations operating under the NFI brand are highlighted when selected regardless of what other brands they are also attached to. Is there a way to do this in the filter pane?
Solved! Go to Solution.
Yes, by creating an extra table in the script with a new field that you can use for the filter pane:
NewFilter: LOAD * INLINE [ Brand, BrandFilter WFI, WFI NFI;PFI, NFI NFI;PFI, PFI PFI, PFI WFI;NFI;JFI, WFI WFI;NFI;JFI, NFI WFI;NFI;JFI, JFI JFI, JFI NFI, NFI ];
What if there's thousands of different combinations? Is there a easier way of scripting this, maybe using wildmatch?
I tried the below but it looks like incorrect syntax.