topic Re: Difference in 2 set expression in QlikView https://community.qlik.com/t5/QlikView/Difference-in-2-set-expression/m-p/83254#M782391 <HTML><HEAD></HEAD><BODY><P>hi </P><P>the first expression will evaluate the expression out side your chart </P><P>what it mean this expression will be calculated at app level and will try to bring back a number </P><P>this method is used when you want to compare to global value like latest month , or max value of a field </P><P>in your case the result will be 0</P><P></P><P>the second expression will create a virtual table with brand as the dimension and evaluate for each brand value his rank </P><P>this expression will work</P></BODY></HTML> Sat, 24 Mar 2018 03:29:22 GMT lironbaram 2018-03-24T03:29:22Z Difference in 2 set expression https://community.qlik.com/t5/QlikView/Difference-in-2-set-expression/m-p/83253#M782390 <HTML><HEAD></HEAD><BODY><P>Please let me know difference between 2 set expression</P><P></P><P>=sum({&lt;Brand = {"$(=rank(sum(Sales))&lt;=2)"}&gt;}Sales)</P><P></P><P>=sum({&lt;Brand = {"=rank(sum(Sales))&lt;=2"}&gt;}Sales)</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Difference-in-2-set-expression/m-p/83253#M782390 shiveshsingh 2020-11-25T16:16:04Z Re: Difference in 2 set expression https://community.qlik.com/t5/QlikView/Difference-in-2-set-expression/m-p/83254#M782391 <HTML><HEAD></HEAD><BODY><P>hi </P><P>the first expression will evaluate the expression out side your chart </P><P>what it mean this expression will be calculated at app level and will try to bring back a number </P><P>this method is used when you want to compare to global value like latest month , or max value of a field </P><P>in your case the result will be 0</P><P></P><P>the second expression will create a virtual table with brand as the dimension and evaluate for each brand value his rank </P><P>this expression will work</P></BODY></HTML> Sat, 24 Mar 2018 03:29:22 GMT https://community.qlik.com/t5/QlikView/Difference-in-2-set-expression/m-p/83254#M782391 lironbaram 2018-03-24T03:29:22Z Re: Difference in 2 set expression https://community.qlik.com/t5/QlikView/Difference-in-2-set-expression/m-p/83255#M782392 <HTML><HEAD></HEAD><BODY><P>Thank You Sir <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Sat, 24 Mar 2018 03:40:03 GMT https://community.qlik.com/t5/QlikView/Difference-in-2-set-expression/m-p/83255#M782392 shiveshsingh 2018-03-24T03:40:03Z