Getting count based on an expression

Sun, 28 Jul 2013 19:40:34 GMT

Hi,

In the below expression I am trying to find the count of distinct products for which % Change in Cost is >=0.

COUNT({<Product={"=if((Sum( {1<Product=p(Product)>} Cost) -

Sum( {1<Product=p(Product)>} Cost_Change))=0,0,

Sum( {1<Product=p(Product)>} Cost_Change)/

(Sum( {1<Product=p(Product)>} Cost) -

Sum( {1<Product=p(Product)>} Cost_Change)))>=0"} >} DISTINCT Product)

But this expression is not returning a correct value if denominator is zero ie if

Sum( {1<Product=p(Product)>} Cost) -

Sum( {1<Product=p(Product)>} Cost_Change)=0

Thanks,

Amit

topic Getting count based on an expression in QlikView

Getting count based on an expression