Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to exclude values in an expression?

Hi,

I have the following expression to include specific values, but how can I do the same to exclude values? this because I have another field that I need to use but exclude just 3 and include the rest:

SUM ({$<[Escalated State]= {'De-Escalated','Resolved/Closed','Escalated'}>}[Escalated Case Count])

How can I do the exclusion?

Please advise.

1 Solution

Accepted Solutions
sunny_talwar

May be this:

Sum({$<[Escalated State] -= {'De-Escalated','Resolved/Closed','Escalated'}>}[Escalated Case Count])

View solution in original post

2 Replies
sunny_talwar

May be this:

Sum({$<[Escalated State] -= {'De-Escalated','Resolved/Closed','Escalated'}>}[Escalated Case Count])

sunny_talwar

or this:

Sum({$<[Escalated State] = e({<[Escalated State] = {'De-Escalated','Resolved/Closed','Escalated'}>})>} [Escalated Case Count])