Set Expression Questions

[Ron1]

Can anyone please help me to understand the meaning of below two set expression parts marked in bold

1) Sum({<Year={'2019'},Month,Country={'Japan'}>}Sales)

2) sum({1<Year =- {'2019'}>} 0)

3) sum({1<Year -= {'2019'}>} 0)

[skamath1]

1) Ignore any selection for the Month

2) and 3) The negative sign -  indicates not equal to '2019'.  But, the expression will always return 0 as the measure field name is not available.  If 0 is replaced with measure field Sales, then it will sum Sales for not equal to 2019. All other selections will be ignored.

[Ron1]

 Are you sure that expression 2 and 3 will always return '0'?

[skamath1 · Accepted solution]

Yes.   It will be zero. do you see any other result in your app?

[rwunderlich · Accepted solution]

#2 and #3 are slightly different. 

#2 means "select all Year not equal to 2019".

#3 means "remove 2019 from the set of possible Year".

They will return the same number in the clear state, but can return different results if any Years are selected.

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com