Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
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.