Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

Try

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

or

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

VishalWaghole
Specialist II
Specialist II

Hello Eric,

You can use this expressions,

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

or

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

- Regards,

Vishal Waghole

Not applicable
Author

Thanks Clark...both of them worked

Not applicable
Author

Thanks Vishal....both of them worked