Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Partner
Partner

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

View solution in original post

5 Replies
Highlighted

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

Highlighted
Partner
Partner

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

View solution in original post

Highlighted
Not applicable

if we need to count distinct value then plz help

Highlighted
Master III
Master III

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

Highlighted
Not applicable

Thanks a lot

it is working fine with below mentioned expression

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