topic Re: Set Expression Questions in App Development

Set Expression Questions

Ron1 — Mon, 10 Feb 2020 13:29:13 GMT

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)

Re: Set Expression Questions

skamath1 — Mon, 10 Feb 2020 13:57:44 GMT

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.

Re: Set Expression Questions

Ron1 — Mon, 10 Feb 2020 14:28:57 GMT

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

Re: Set Expression Questions

skamath1 — Mon, 10 Feb 2020 14:48:13 GMT

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

Re: Set Expression Questions

rwunderlich — Mon, 10 Feb 2020 15:06:42 GMT

#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