Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Re: Why isn't COUNT DISTINCT working properly?

It says "Text Object"

MVP
MVP

Re: Why isn't COUNT DISTINCT working properly?

Well, hard to tell what's going on using the information provided.

There might be multiple things that may affect your distinct count() in different chart objects: Use of set analysis, alternate states, detached objects ...

Employee
Employee

Re: Why isn't COUNT DISTINCT working properly?

Is ITMSNumber a key? You should avoid counting key fields

Re: Why isn't COUNT DISTINCT working properly?

Distinct counting a key field should not be a problem as mentioned my HIC here Count or Count distinct?

Capture.PNG