topic Re: sehow to write set analysis in QlikView https://community.qlik.com/t5/QlikView/sehow-to-write-set-analysis/m-p/385467#M565139 <HTML><HEAD></HEAD><BODY><P>Jagan</P><P></P><P></P><P>jagan&nbsp; thank you&nbsp; it is&nbsp; working fine </P></BODY></HTML> Wed, 02 Jan 2013 06:36:26 GMT 2013-01-02T06:36:26Z sehow to write set analysis https://community.qlik.com/t5/QlikView/sehow-to-write-set-analysis/m-p/385464#M565136 <HTML><HEAD></HEAD><BODY><P>=if((Datefield) &lt; startdate ,(sum(if(ABC ='C,'XYZ))) - (sum(if(ABC ='D',XYZ))))</P><P></P><P></P><P>same&nbsp; expression&nbsp; i need in&nbsp;&nbsp; set analysis</P></BODY></HTML> Wed, 02 Jan 2013 05:51:57 GMT https://community.qlik.com/t5/QlikView/sehow-to-write-set-analysis/m-p/385464#M565136 2013-01-02T05:51:57Z Re: sehow to write set analysis https://community.qlik.com/t5/QlikView/sehow-to-write-set-analysis/m-p/385465#M565137 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>if((Datefield) &lt; startdate ,sum({&lt;ABC ={'C','XYZ'}&gt;}) - sum({&lt;ABC ={'D','XYZ'}&gt;}))</P></BODY></HTML> Wed, 02 Jan 2013 06:18:21 GMT https://community.qlik.com/t5/QlikView/sehow-to-write-set-analysis/m-p/385465#M565137 2013-01-02T06:18:21Z Re: sehow to write set analysis https://community.qlik.com/t5/QlikView/sehow-to-write-set-analysis/m-p/385466#M565138 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this</P><P></P><P>=Sum({&lt;Datefield={'&lt;$(=startdate)'}, ABC = {'C'} &gt;} XYZ) - Sum({&lt;Datefield={'&lt;$(=startdate)'}, ABC = {'D'} &gt;} XYZ)</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Wed, 02 Jan 2013 06:19:32 GMT https://community.qlik.com/t5/QlikView/sehow-to-write-set-analysis/m-p/385466#M565138 jagan 2013-01-02T06:19:32Z Re: sehow to write set analysis https://community.qlik.com/t5/QlikView/sehow-to-write-set-analysis/m-p/385467#M565139 <HTML><HEAD></HEAD><BODY><P>Jagan</P><P></P><P></P><P>jagan&nbsp; thank you&nbsp; it is&nbsp; working fine </P></BODY></HTML> Wed, 02 Jan 2013 06:36:26 GMT https://community.qlik.com/t5/QlikView/sehow-to-write-set-analysis/m-p/385467#M565139 2013-01-02T06:36:26Z