Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

Straight table Counting Single variable within Dimensions Query

Hello,

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.

Count.PNG

2 Replies
sunny_talwar

May be you need this:

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

mohiahmed
Contributor III
Contributor III
Author

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