Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
TomBond77
Specialist
Specialist

count distinct order not working

Hi experts

This formula shows the wrong total of count. In year 2023 it give 690, a download by excel shows 299. Any ideas?

count ( distinct [Order])

Thank you!

Labels (4)
1 Solution

Accepted Solutions
marcus_sommer

The combination of field-values within an object in Qlik is always distinct - so your object may not be granular enough to return your expected results - but the total-row for the calculation within Qlik should show the correct amount.

View solution in original post

1 Reply
marcus_sommer

The combination of field-values within an object in Qlik is always distinct - so your object may not be granular enough to return your expected results - but the total-row for the calculation within Qlik should show the correct amount.