topic Re: set analysis in QlikView https://community.qlik.com/t5/QlikView/set-analysis/m-p/1168492#M886036 <HTML><HEAD></HEAD><BODY><P>thank you so much sunny</P></BODY></HTML> Fri, 09 Sep 2016 09:13:13 GMT 2016-09-09T09:13:13Z set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/1168488#M886032 <HTML><HEAD></HEAD><BODY><P>hi Experts,</P><P></P><P>i have the following expression</P><P><STRONG>sum({&lt;Handover= {'*'}-{}&gt;}TimeArrival)</STRONG></P><P></P><P>i dont understand what is this calculating.</P><P></P><P>can anyone please explain me</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/1168488#M886032 2020-11-25T16:16:04Z Re: set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/1168489#M886033 <HTML><HEAD></HEAD><BODY><P>This should be same as </P><P><STRONG>Sum({&lt;Handover = {'*'}&gt;} TimeArrival)</STRONG></P><P></P><P>do you see any difference in result when you use the two expressions? The above is just saying that include all rows where Handover is not null.</P></BODY></HTML> Thu, 08 Sep 2016 15:30:14 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/1168489#M886033 sunny_talwar 2016-09-08T15:30:14Z Re: set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/1168490#M886034 <HTML><HEAD></HEAD><BODY><P>no sunny.</P><P>i dont see any difference.</P><P></P><P>both are giving same value</P></BODY></HTML> Thu, 08 Sep 2016 15:32:50 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/1168490#M886034 2016-09-08T15:32:50Z Re: set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/1168491#M886035 <HTML><HEAD></HEAD><BODY><P>Then like I said, the expression is including all rows in the expression where Handover is not null.</P></BODY></HTML> Thu, 08 Sep 2016 15:34:01 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/1168491#M886035 sunny_talwar 2016-09-08T15:34:01Z Re: set analysis https://community.qlik.com/t5/QlikView/set-analysis/m-p/1168492#M886036 <HTML><HEAD></HEAD><BODY><P>thank you so much sunny</P></BODY></HTML> Fri, 09 Sep 2016 09:13:13 GMT https://community.qlik.com/t5/QlikView/set-analysis/m-p/1168492#M886036 2016-09-09T09:13:13Z