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