Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Ron1
Partner - Creator
Partner - Creator

Set Expression Questions

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)

2 Solutions

Accepted Solutions
skamath1
Creator III
Creator III

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

View solution in original post

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

#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

View solution in original post

4 Replies
skamath1
Creator III
Creator III

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
Partner - Creator
Partner - Creator
Author

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

skamath1
Creator III
Creator III

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

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

#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