Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

hammermill21
Contributor II

Table Counting Based on Answer

Hello,

I have a table that has an inventory count, then a count of a pass and failed. To calculate the Pass or fail I'm using this:

Count({<[Bascom Pass]={'YES'}>}[Bascom Pass])

Count({<[Bascom Pass]={'NO'}>}[Bascom Pass])

But my problem is that it gives me the total for all the inventory item instead of breaking it down. When it should be For example for Exit Lights, Passed 295 and Failed 3. I've tried a few ways and nothing seems to be working.

Capture.PNG

Can someone help

1 Solution

Accepted Solutions

Re: Table Counting Based on Answer

What is the exact expression you are using?

Is [Bascom Pass] is associated with [LS Component]

3 Replies

Re: Table Counting Based on Answer

What is the exact expression you are using?

Is [Bascom Pass] is associated with [LS Component]

mdmukramali
Valued Contributor II

Re: Table Counting Based on Answer

Hi,

Can you share the expression?

hammermill21
Contributor II

Re: Table Counting Based on Answer

Hey Manish,

That's what the problem was. I thought it was associated but when I reloaded I realized something was changed in the backend. It is working now.

Thank you!

Community Browser