Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Count expression

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

4 Replies
Not applicable

Re: Count expression

Try

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

or

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

vishalwaghole
Valued Contributor II

Re: Count expression

Hello Eric,

You can use this expressions,

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

or

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

- Regards,

Vishal Waghole

Not applicable

Re: Count expression

Thanks Clark...both of them worked

Not applicable

Re: Count expression

Thanks Vishal....both of them worked

Community Browser