topic Re: Using Expression to Exclude Item in Filter Pane in QlikView

Using Expression to Exclude Item in Filter Pane

Wed, 22 Oct 2014 07:40:24 GMT

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!

Re: Using Expression to Exclude Item in Filter Pane

ashfaq_haseeb — Wed, 22 Oct 2014 08:15:37 GMT

Hi,

Can you come-up with proper example.

Have a look at attached document to understand Set Analysis

Regards

ASHFAQ

Re: Using Expression to Exclude Item in Filter Pane

Gysbert_Wassenaar — Wed, 22 Oct 2014 08:16:39 GMT

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.

Re: Using Expression to Exclude Item in Filter Pane

Thu, 23 Oct 2014 03:41:18 GMT

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.

Re: Using Expression to Exclude Item in Filter Pane

Gysbert_Wassenaar — Thu, 23 Oct 2014 16:42:15 GMT

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.

Re: Using Expression to Exclude Item in Filter Pane

Mon, 10 Nov 2014 23:53:58 GMT

Thank you Gysbert! Appreciate the help!