Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Try like:
Count(Distinct {<Name={"=Sum(Value)>0"}>}Name)
may be this as well without Set analysis?
=If(Value>0, Count(Name) or Count(distinct(Name)))
And if aonly positive values need to be counted:
try this:
count({$< Value = {">0"} >}Name)
Maybe 0 should also be included:
=Count(Distinct {<Name={"=Sum(Value)>=0"}>}Name)
Was asked for 'positive' and zero (0) is not a positive number.
Thanks all,
It helpfully.