topic AW:Chart total wrong in QlikView

Chart total wrong

david_ze — Wed, 23 Mar 2011 14:58:39 GMT

hi,

I have a strange issue...

I use straight table: Dimenssion is Date and have about 12 expressions 10 of them are sum(XXX).

Rest are Count expressions and their totals are wrong...the expressions are:

count(DISTINCT initiated_users)

count(DISTINCT slideUp_users)

I've exported the data to excel and saw that only in these columns the total is not right.

will appreciate your advice.

Thanks in advance

David

AW:Chart total wrong

brenner_martina — Wed, 23 Mar 2011 15:01:13 GMT

Hi David,

do you have any syntetic keys in your data model? And what is wrong?

AW:Chart total wrong

david_ze — Wed, 23 Mar 2011 15:08:45 GMT

No, don't have syntetic keys. The thing is that the total is not correct in these two tables.

AW:Chart total wrong

kji — Wed, 23 Mar 2011 15:16:41 GMT

Check which kind of total you are using, most likely you have it on "Expression Total" but want to use "Sum of Rows".

Chart total wrong

Wed, 23 Mar 2011 15:21:26 GMT

Hi David, the issue here might be that the default expression for populate the total's row is the "expression total" meaning that the expression count(DISTINCT initiated_users) is evaluated without a single dimension, the difference you noticed when you exported the data is because there are values of initiated_users that might be repeated across different dates; this way the total row will always show the count of distinct initiated_users in all the dates available. If you want to sum the rows within the count expression just check the "sum of rows options" under the expressions tab. Another option could be using a expression similar to the following:

sum(aggr(count(DISTINCT initiated_users) ,Date))

Hope this helps.

Regards

AW:Chart total wrong

david_ze — Wed, 23 Mar 2011 15:31:12 GMT

John thanks,

I've changed it to sum of rows and it works perfect.

Thank you all for helping

David