https://community.qlik.com/t5/App-Development/QlikView-Set-Analysis/m-p/2024876#M84527 <P>Hi&nbsp;</P> <P>Can someone help me with the set expression for below .</P> <P>Attached a sample data S/S . My goal here is to calculate Count([TradeCount]) , where I need to exclude data where ever Revenue=0, even if Trade Count or volume is not Zero. I am trying to achieve this in Pivot Chart.</P> Thu, 12 Jan 2023 10:58:40 GMT jyoshna 2023-01-12T10:58:40Z https://community.qlik.com/t5/App-Development/QlikView-Set-Analysis/m-p/2024876#M84527 <P>Hi&nbsp;</P> <P>Can someone help me with the set expression for below .</P> <P>Attached a sample data S/S . My goal here is to calculate Count([TradeCount]) , where I need to exclude data where ever Revenue=0, even if Trade Count or volume is not Zero. I am trying to achieve this in Pivot Chart.</P> Thu, 12 Jan 2023 10:58:40 GMT https://community.qlik.com/t5/App-Development/QlikView-Set-Analysis/m-p/2024876#M84527 jyoshna 2023-01-12T10:58:40Z https://community.qlik.com/t5/App-Development/QlikView-Set-Analysis/m-p/2025510#M84570 <P>Try</P><P>Count({&lt;Sales Group-={"=Sum(Revenue)=0"}&gt;} [TradeCount])</P><P>PS Are you sure you mean Count(TradeCount) and not Sum(TradeCount)?</P> Fri, 13 Jan 2023 13:44:30 GMT https://community.qlik.com/t5/App-Development/QlikView-Set-Analysis/m-p/2025510#M84570 hic 2023-01-13T13:44:30Z