Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
mwallman
Creator III
Creator III

What is the difference between using =- and -= in Set Analysis?

Hello,

What is the difference between using =- and -= in Set Analysis?

For example: Sum({<Country=-{'Sweden'}>}Sales) and Sum({<Country-={'Sweden'}>}Sales).


Is it that -= will exclude Sweden from your selections if Sweden is selected? And =- will exclude it regardless of whether it is selected or not?


Which is the recommended option if you want to exclude Sweden?

3 Replies
sunny_talwar

-= will honor selection... meaning if you select India as a country....Sum({<Country-={'Sweden'}>}Sales) will show sum of just sales from India. But =- will disregard selection... meaning if you select India as Country.... Sum({<Country=-{'Sweden'}>}Sales) will continue to show the sum of sales for all countries except Sweden


EDIT: Made changes to my reply above

mwallman
Creator III
Creator III
Author

Hi Sunny,

The =- will not honour the selection? E.g. If I select India, it will only show the sales for India? And if nothing is selected it will show sales for all, except Sweden?

Neymar_Jr
Creator II
Creator II

Even if you select India, it will still show sales of all the countries except Sweden.