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

Total Count of rows with a specific value in field

Hi,

I have a column called withinresp, where the result is either going to be 0 or 1.  However I would like to know the exact number of the value 0, in the field called withinresp using a text object.  Would someone be able to help me with the query please?

1 Solution

Accepted Solutions
giakoum
Partner - Master II
Partner - Master II

count({$<[withinresp]={0}>} withinresp)

View solution in original post

5 Replies
Nicole-Smith

=count({<withinresp=0>}withinresp)

giakoum
Partner - Master II
Partner - Master II

count({$<[withinresp]={0}>} withinresp)

Not applicable
Author

if we need to count distinct value then plz help

anbu1984
Master III
Master III

=count(distinct {<withinresp=0>}withinresp)

Not applicable
Author

Thanks a lot

it is working fine with below mentioned expression

count(distinct {$<[withinresp]={0}>} withinresp)