topic Re: What is the difference between using =- and -= in Set Analysis? in App Development

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

mwallman — Fri, 17 Aug 2018 14:13:42 GMT

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?

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

sunny_talwar — Fri, 17 Aug 2018 14:23:24 GMT

-= 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

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

mwallman — Tue, 21 Aug 2018 12:31:05 GMT

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?

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

Neymar_Jr — Tue, 21 Aug 2018 12:34:10 GMT

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