Count Dimension only if Measure is positive

[ziabobaz]

Trying to make simple calculation, tried both of below formulas, neither worked (still counts brands with Qty=0), please, help:

1. if(sum( [SalesQty]) > 0, count( distinct [Brand]),0)

2. count(

aggr(sum( {<SalesQty={">0"}>} Qty, Brand)

)

[arulsettu]

may be like this

count(

aggr(sum( {<SalesQty={">0"}>} Qty), Brand)

)

[agigliotti]

let's try this expression below:

count( {< Brand = {"=Sum(SalesQty)>0"} >} distinct Brand )

Hope it helps.

[prat1507]

Maybe this

Count(if(Aggr(sum( [SalesQty]),Brand)>0,Brand))

[ogautier62]

Hi

or maybe this :

sum(if(aggr(sum(SalesQty),Brand) >0,1))

[sunny_talwar · Accepted solution]

How about this

Count(DISTINCT {<Brand = {"=Sum([SalesQty]) > 0"}>} [Brand])

[isingh30]

May be this -

count(if(sum( [SalesQty]) > 0, distinct [Brand]))

[ziabobaz]

the result includes 0 values

[ziabobaz]

the result returns "-"

[sunny_talwar]

QlikView and Qlik Sense are case sensitive, have you checked if the field names are right?