https://community.qlik.com/t5/QlikView/restriction-between-2-set-analysis/m-p/1564522#M741625 <P>May be this</P><P>Expression CA net</P><PRE>If(Sum({&lt;Mouvement_ID={"VC"}&gt;} Total_Net_HT) = 0, Sum({&lt;Mouvement_ID={'AC'},Date={"&gt;=$(vDateP1D)&lt;=$(vDateP1F)"}, Typologie ={"NEW"}&gt;} Total_Net_HT) )</PRE><P>Expression Ventes</P><PRE>If(Sum({&lt;Mouvement_ID={"VC"}&gt;} Total_Net_HT) = 0, Sum({&lt;Mouvement_ID={"VC"}&gt;} Total_Net_HT) )</PRE> Wed, 03 Apr 2019 12:02:34 GMT sunny_talwar 2019-04-03T12:02:34Z https://community.qlik.com/t5/QlikView/restriction-between-2-set-analysis/m-p/1564440#M741624 <P><SPAN>Hello,</SPAN></P><P><SPAN>I want to show only the rows where&nbsp; "Ventes" = 0&nbsp;</SPAN></P><P><SPAN>Expression CA net:&nbsp;&nbsp;Sum({&lt;Mouvement_ID={'AC'},Date={"&gt;=$(vDateP1D)&lt;=$(vDateP1F)"}, Typologie ={"NEW"}&gt;} Total_Net_HT)</SPAN></P><P><SPAN>Expression Ventes:&nbsp;&nbsp;Sum({&lt;Mouvement_ID={"VC"}&gt;} Total_Net_HT)</SPAN></P><P><SPAN><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Img1.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/9355i1EE7D8AF4528C6AF/image-size/large?v=v2&amp;px=999" role="button" title="Img1.png" alt="Img1.png" /></span></SPAN></P><P>&nbsp;</P><P><SPAN>Thank you</SPAN></P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/restriction-between-2-set-analysis/m-p/1564440#M741624 Mahmoud 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/restriction-between-2-set-analysis/m-p/1564522#M741625 <P>May be this</P><P>Expression CA net</P><PRE>If(Sum({&lt;Mouvement_ID={"VC"}&gt;} Total_Net_HT) = 0, Sum({&lt;Mouvement_ID={'AC'},Date={"&gt;=$(vDateP1D)&lt;=$(vDateP1F)"}, Typologie ={"NEW"}&gt;} Total_Net_HT) )</PRE><P>Expression Ventes</P><PRE>If(Sum({&lt;Mouvement_ID={"VC"}&gt;} Total_Net_HT) = 0, Sum({&lt;Mouvement_ID={"VC"}&gt;} Total_Net_HT) )</PRE> Wed, 03 Apr 2019 12:02:34 GMT https://community.qlik.com/t5/QlikView/restriction-between-2-set-analysis/m-p/1564522#M741625 sunny_talwar 2019-04-03T12:02:34Z https://community.qlik.com/t5/QlikView/restriction-between-2-set-analysis/m-p/1565000#M741626 <P>it works, Thank youuu <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Thu, 04 Apr 2019 08:43:48 GMT https://community.qlik.com/t5/QlikView/restriction-between-2-set-analysis/m-p/1565000#M741626 Mahmoud 2019-04-04T08:43:48Z