Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Seamus
Contributor
Contributor

A simple expression to exclude

Is there a simple expression such as Exclude that I can use to not ever display one value in a pie chart  . I just want to always exclude Not Assigned. I would like exclude=Not assigned ?

Seamus_0-1628272555614.png

 

Labels (1)
1 Solution

Accepted Solutions
Or
MVP
MVP

Add set analysis to your formula, e.g.

sum({< YourDimension -= {"Not assigned} >} YouMeasure)

View solution in original post

1 Reply
Or
MVP
MVP

Add set analysis to your formula, e.g.

sum({< YourDimension -= {"Not assigned} >} YouMeasure)