Using Expression to Exclude Item in Filter Pane

[#1]

Hello,

I'm fairly new to Qlik and Set Analysis. I'm currently trying to exclude a blank value in the filter pane using custom expression in the sorting pane. The field I am using is "Priority".

Here is what I have so far and its throwing an error:

match(Priority,(-=''))

Thank you!

[ashfaq_haseeb]

Hi,

Can you come-up with proper example.

Have a look at attached document to understand Set Analysis

Regards

ASHFAQ

[Gysbert_Wassenaar]

Can you tell me what kind of object you're using? I don't know of any objects that have a filter pane. It's not possible to filter values on the Sort pane of an object. That's for sorting only.

If you want to exclude a blank value, you can select it, then right click it and choose Select Excluded to invert the selection.

[#4]

I am using a separate Filter pane object, here is a screenshot. It is currently showing the blank value on top under Priority. Right clicking only allows me to delete the entire filter pane object.

[Gysbert_Wassenaar · Accepted solution]

Ah, you're not using Qlikview but Qlik Sense. What does not change is that you cannot filter values using an expression on the Sorting pane. The sorting pane is for sorting data, not filtering data. Aside from that the expression you're using is not correct. Look up the match function in the help file to see how it should be used.

[#6]

Thank you Gysbert! Appreciate the help!