Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Straight table Counting Single variable within Dimensions Query


I have set up a straight table and in there I am trying to get a count of from one of the dimensions.  Its called Check Results and trying to get count of Failed Conformance and Failed Compliance.  There is another variable in dimension (Check Result) and don't want to bring that through. Every time I am doing a count it keeps coming back with count of all rather than a single variable.

Please see attached, and if you can give me some pointers that would be truly appreciated.


2 Replies

May be you need this:

Count({<[Check Result] = {'Failed Conformance', 'Failed Compliance'}>} [Check Result])

Contributor III
Contributor III

Thanks you Sunny, that was very helpful just what I needed.