topic Re: Count if in QlikView

Count if

Tue, 09 Sep 2014 17:17:33 GMT

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

Re: Count if

aveeeeeee7en — Tue, 09 Sep 2014 17:32:11 GMT

Try this:

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

Hope that helps.

Regards

Aviral Nag

Re: Count if

Gysbert_Wassenaar — Tue, 09 Sep 2014 17:33:43 GMT

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

Re: Count if

israrkhan — Tue, 09 Sep 2014 17:35:00 GMT

try

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

Hope it helps...

Re: Count if

Tue, 09 Sep 2014 19:25:24 GMT

Return zero

Re: Count if

Tue, 09 Sep 2014 19:25:50 GMT

do not work return 0

Re: Count if

maxgro — Tue, 09 Sep 2014 19:40:56 GMT

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

Re: Count if

israrkhan — Tue, 09 Sep 2014 19:48:32 GMT

try

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

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

SHOULD WORK...

Re: Count if

Tue, 09 Sep 2014 20:21:08 GMT

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

Re: Count if

MarcoWedel — Tue, 09 Sep 2014 22:45:46 GMT

Sum(Sign(mono_usg))

Re: Re: Count if

MarcoWedel — Tue, 09 Sep 2014 22:51:06 GMT

hope this helps

regards

Marco

Re: Count if

nagaiank — Wed, 10 Sep 2014 04:18:45 GMT

The solution given by gwassenaar works for me.