Total count distinct produce wrong sum

[#1]

Hi all,

i really don't succeed in explaining the behaviour of qlikview in the attached document.

The automatic sum (TOTAL) on the column where i perform a count(distinct...) produce a wrong automatic sum.

Can someone help me to understand this behaviour and to find a solution?

Thanks in advance.

[Gysbert_Wassenaar · Accepted solution]

The expression is used at the total level too. So it returns the overall count distinct. There is no automatic sum, because it's an automatic count distinct (which is correct). If you want to sum the rows you can do two things.

1. Set the total mode of the expression to Sum of Rows;

2. Use sum(aggr(count(distinct number),category)) as expression.

[#3]

Thanks, I resolved using the first option.