Count if

[#1]

Hello to all,

I'm new in qlikview, and I need to know how to count records with value >0

I have a calculated field with count(mono_usg) but I want to count only the records with a value > 0

Thanks in advance

[aveeeeeee7en]

Hi

Try this:

count({<Value={'>0'}>}mono_usg)

Hope that helps.

Regards

Aviral Nag

[Gysbert_Wassenaar]

count({<mono_usg={'>0'}>}mono_usg)

[israrkhan]

try

count({<Value -= {0}>} mono_usg)

Hope it helps...

[#5]

Return zero

[#6]

do not work return 0

[maxgro]

=count(if(mono_usg>0,mono_usg))

[israrkhan]

try

count({<mono_usg-= {0}>} mono_usg) OR

count({<mono_usg= {" > 0 "}>} mono_usg)

SHOULD WORK...

[#9]

This may seem like a very basic answer, but have you confirmed that you imported data that actually fulfills when this condition is true?

[MarcoWedel]

Sum(Sign(mono_usg))