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: 
Anonymous
Not applicable

Exclude with IF in SUM expression Set-Analysis

Hi All,

let's assume I have the following categories and the measure Nett Amount:

Category

Subcategory

A1
2
3
B
C
D

As measure, I want to use the SUM of sales of all the categories: SUM([Nett Amount])

To get an accurate overview of the sales, I want the SUM Nett Amount of all the categories without subcategory A2.

So there is one field that has to be excluded.

I tried such an expression like: SUM((IF(Not match(Subcategory,2)Subcategory))[Nett Amount]), but that didn't work.

How do I write such an expression?


Thanks a lot!

Mike

12 Replies
ogster1974
Partner - Master II
Partner - Master II

Another example of the solution including a bookmark option if you want to keep C in your charts and just exclude in particular circumstances.

Anonymous
Not applicable
Author

Yeah thanks a lot Sunny! When having a look at your testfile, I realised I had to add the expression to both of my measures in my scatter plot.. That was pretty dumb, bt it works exactly as I wanted now:)

Anonymous
Not applicable
Author

Thanks for your reply Andy! I was familiar with the bookmark, but that is indeed a good solution if you want to be able to switch between the two options:)