Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Cnt Expression

.

1 Reply
sunny_talwar

The problem with Distinct count is that it is dependent on your dimension. So it is distinct per your dimension. Look at an example where I have selected one Result.

Capture.PNG

Now you have to decide that would this be part of SN or SN-HIDE in your Invoice field. Both are correct, but if you want the bar chart's sum to match with sum of straight table's row, one of the two Invoice have to go away, right? Which one would that be?