topic Re: Count measure not counting correctly when filtering in App Development

Count measure not counting correctly when filtering

alespooletto — Thu, 29 Feb 2024 13:23:11 GMT

I have an issue with my measure, which supposedly only counts specific action codes.

The measure is

```

COUNT( ACTION_CODE = 'LABOR_OFF')

```

But when I insert it into the table, I don't get the right counts and shows as in the screenshot that it counts also when ACTION_CODE = 'LABOR_ON'

Is there any solution to this?

Re: Count measure not counting correctly when filtering

theoat — Thu, 29 Feb 2024 13:33:49 GMT

Try this :
Count({<ACTION_CODE={"LABOR_OFF"}>}distinct Employee)

Enjoy your Qlik.

Kind regards,
Théo ATRAGIE.

Re: Count measure not counting correctly when filtering

Clement15 — Thu, 29 Feb 2024 13:34:21 GMT

Hello, could this be suitable?

count({<ACTION_CODE = {'LABOR_OFF'}>} ACTION_CODE )

Re: Count measure not counting correctly when filtering

alespooletto — Thu, 29 Feb 2024 14:16:30 GMT

Thank you, this gives me a 1 as result, which would work fine if I needed to check what an employee did on a specific SFC without counting all the SFCs at once. I needed one that would count, for all the SFCs done, the number of which had action code = labor off. The response by @Clement15 actually provided the solution, thank you all!