topic Straight table Counting Single variable within Dimensions Query in QlikView

Straight table Counting Single variable within Dimensions Query

mohiahmed — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Straight table Counting Single variable within Dimensions Query

sunny_talwar — Fri, 07 Oct 2016 16:03:17 GMT

May be you need this:

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

Re: Straight table Counting Single variable within Dimensions Query

mohiahmed — Tue, 11 Oct 2016 12:35:00 GMT

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