Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
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?

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.