Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
hammermill21
Contributor III

Distinct Count of Bar Codes

Hello Everyone,

I have the expression:

Count({<Inspected={'Not Inspected'}>}Inspected)

which count all the items that have not been inspected but I need to add to it to count all the distinct bar codes that have not been inspected. I tried adding count distinct Bar Code but the expression is incorrect.

Can anyone help? Thanks!

1 Solution

Accepted Solutions

Re: Distinct Count of Bar Codes

So, you are saying that this isn't working?

Count(DISTINCT {<Inspected={'Not Inspected'}>} [bar codes])

2 Replies

Re: Distinct Count of Bar Codes

So, you are saying that this isn't working?

Count(DISTINCT {<Inspected={'Not Inspected'}>} [bar codes])

hammermill21
Contributor III

Re: Distinct Count of Bar Codes

Hey Sunny,

You are correct, I must have written the expression wrong in some way.

Thanks!