# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for
Did you mean:
Contributor III

## Set analysis

Hey,
I have a question about set analysis.
I would like to select the turnover of all customers except 4. I have no idea how I can filter this via set analysis. I thought of Sum ({1 - \$ <CustomerID = {1120,1121,1122,1123}>} Total sales) but it does not work: P

does anyone have any idea what I'm doing wrong?

5 Replies
Partner

Hi Willem,

please see the following for Set Analysis Exclusion:

Excluding values in Set Analysis

Best regaards

Andy

Master III

Try

Sum ({1<CustomerID -= {1120,1121,1122,1123}>} Total sales)

Specialist III

you can try -

if you want to include any current selections:

Sum ({\$<CustomerID = {'*'} - {1120,1121,1122,1123}>} Total sales)

or

Sum ({\$<CustomerID -= {1120,1121,1122,1123}>} Total sales)

if you want to exclude all current selections:

Sum ({1<CustomerID = {'*'} - {1120,1121,1122,1123}>} Total sales)

or

Sum ({1<CustomerID -= {1120,1121,1122,1123}>} Total sales)

Creator III

Sum ({\$<CustomerID = {'*'} - {'4'}>} sales)

Contributor III
Author

Thankyou all!

All the solutions did work out

Tags