topic Chart not adding correctly in QlikView

Chart not adding correctly

camilo — Tue, 27 Jul 2010 22:11:01 GMT

Hi,

I did a table where I´m using the following expression:

=sum(distinct(Kg*Multiplicador))

But the partial sum filed does not add the numbers correctly it should say 4.636 but is showing 4.488:

How can I post a box with a qvw example in this topic, I´ve seen that on several topics.

Thanks

Chart not adding correctly

Tue, 27 Jul 2010 23:31:14 GMT

The option to 'attach' is at the top of the page where you write your posts, under the 'options' tab.

Chart not adding correctly

camilo — Tue, 27 Jul 2010 23:58:39 GMT

Thank you very much, here is the model with the chart.

Any help is more than welcome!

Chart not adding correctly

Wed, 28 Jul 2010 01:46:37 GMT

In Pivot table, the total is usually the expression total and not the total of the row. This works fine till you use something like distinct which at each row level would be diffirent than at the total level.

You need to use the aggr function to achieve the total of the rows.

=Sum( aggr(sum(distinct(Kg*Multiplicador)),Embalaje,Calibre,Embalaje_Eq,Calibre_Eq))

Nimish

Chart not adding correctly

camilo — Wed, 28 Jul 2010 14:51:44 GMT

Thank you very much Nimish it worked perfect