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: 
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:)