Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Using Expression to Exclude Item in Filter Pane

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!

1 Solution

Accepted Solutions

Re: Using Expression to Exclude Item in Filter Pane

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.


talk is cheap, supply exceeds demand
5 Replies

Re: Using Expression to Exclude Item in Filter Pane

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

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.


talk is cheap, supply exceeds demand
Not applicable

Re: Using Expression to Exclude Item in Filter Pane

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.

screenshot.JPG

Re: Using Expression to Exclude Item in Filter Pane

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.


talk is cheap, supply exceeds demand
Not applicable

Re: Using Expression to Exclude Item in Filter Pane

Thank you Gysbert! Appreciate the help!

Community Browser