Qlik Community

New to Qlik Sense

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

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
thewillemzelluf
Contributor III
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
awhitfield
Partner
Partner

Hi Willem,

please see the following for Set Analysis Exclusion:

Excluding values in Set Analysis

Best regaards

Andy

sasiparupudi1
Master III
Master III

Try

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

krishna_2644
Specialist III
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)

sagarkharpude
Creator III
Creator III

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

thewillemzelluf
Contributor III
Contributor III
Author

Thankyou all!

All the solutions did work out