Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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)