topic Re: Count expression in QlikView

Count expression

Tue, 01 Apr 2014 18:26:56 GMT

Hi,

I need to count the values different of 0 (zero) in a specific column. I have tried different ways like Count(Planned), Count(Planned <> 0), but they didn't work as should be?

Any clue?

Thanks

Re: Count expression

Tue, 01 Apr 2014 18:28:21 GMT

Try

=COUNT(IF(Planned <>0,Planned))

=COUNT({<Planned -={'0'}>}Planned)

Re: Count expression

VishalWaghole — Wed, 02 Apr 2014 04:36:15 GMT

Hello Eric,

You can use this expressions,

=count({<Planned = {' * '} - {' 0 '}>}Planned)

=count({<Planned -= {' 0 '}>}Planned)

- Regards,

Vishal Waghole

Re: Count expression

Wed, 02 Apr 2014 11:20:02 GMT

Thanks Clark...both of them worked

Re: Count expression

Wed, 02 Apr 2014 11:20:34 GMT

Thanks Vishal....both of them worked