topic Re: Total count distinct produce wrong sum in QlikView

Total count distinct produce wrong sum

Fri, 07 Nov 2014 12:30:45 GMT

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.

Re: Total count distinct produce wrong sum

Gysbert_Wassenaar — Fri, 07 Nov 2014 12:37:08 GMT

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.

Re: Total count distinct produce wrong sum

Fri, 07 Nov 2014 12:42:24 GMT

Thanks, I resolved using the first option.