Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Yes. It will be zero. do you see any other result in your app?
#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
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.
Are you sure that expression 2 and 3 will always return '0'?
Yes. It will be zero. do you see any other result in your app?
#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