Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Why isn't COUNT DISTINCT working properly?

So I have a problem. With every other text box where I put =COUNT({<[Pr Yr] = {2017}, DOINVSTATUSID = {20}, LOADPRIORITYSTATUSID = {30}>} DISTINCT ITMSNumber) it works fine, but there are two text objects where the count distinct function is returning 4 of the same ITMSNumber's. It should only be returning 1 with the same ITMSNumber.

Why is this happening and how can I fix it?

13 Replies
MVP & Luminary
MVP & Luminary

Re: Why isn't COUNT DISTINCT working properly?

Have you tried deleting the text boxes and replacing them with new ones?


talk is cheap, supply exceeds demand

Re: Why isn't COUNT DISTINCT working properly?

Are you sure they are the same? Even the casing matches? Can you may be share a screenshot of them?

Not applicable

Re: Why isn't COUNT DISTINCT working properly?

dupes.PNG

Not applicable

Re: Why isn't COUNT DISTINCT working properly?

I just deleted the text box and created a new one. It solved the problem I was having but it's still showing more data when exported to XL than what it says in the box. I'll have to create a new thread. Thank you!

Not applicable

Re: Why isn't COUNT DISTINCT working properly?

Nevermind it didn't fix it

Re: Why isn't COUNT DISTINCT working properly?

Would you be able to share a sample?

Not applicable

Re: Why isn't COUNT DISTINCT working properly?

A sample of what? The data or the Dashboard? I can't share the dashboard because it's proprietary and confidential.

Re: Why isn't COUNT DISTINCT working properly?

Highlighted
MVP
MVP

Re: Why isn't COUNT DISTINCT working properly?

Are you sure you are talking about text boxes with a simple expression?

At least it doesn't look like text boxes when looking at your second post.