QlikView Set Analysis

[jyoshna]

Hi 

Can someone help me with the set expression for below .

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.

[hic]

Try

Count({<Sales Group-={"=Sum(Revenue)=0"}>} [TradeCount])

PS Are you sure you mean Count(TradeCount) and not Sum(TradeCount)?