Count field name form positive value

[#1]

Hi Master QS.

I have some problem to make set analytic.

From Data 1 how Qlik Sense count Name based on the sum Value but only positive sum of Value are calculated??

Please advise..

Thanks.

[reddy-s]

Hi Mrdee,

count(Name) should work just fine even if there are negative values. If the problem still persists a sample qvf will be very helpful.

Thanks,

Sangram

[tresesco]

Try like:

Count(Distinct {<Name={"=Sum(Value)>0"}>}Name)

[Anonymous]

may be this as well without Set analysis?

=If(Value>0, Count(Name) or Count(distinct(Name)))

[reddy-s]

And if aonly positive values need to be counted:

try this:

count({$< Value = {">0"} >}Name)

[sunny_talwar]

Maybe 0 should also be included:

=Count(Distinct {<Name={"=Sum(Value)>=0"}>}Name)

[tresesco]

Was asked for 'positive' and zero (0) is not a positive number.

[#8]

Thanks all,

It helpfully.