topic Re: Total related problem in Column of Chart in QlikView

Total related problem in Column of Chart

Tue, 11 Jun 2013 04:32:47 GMT

I want to add subtotal of one Column,But it takes total of next column.

(In Chart Properties->Presentation Tab->Select Dimensions and Expression,Tick on Show partial sum)

But it takes next column total.

Re: Total related problem in Column of Chart

Tue, 11 Jun 2013 05:15:22 GMT

Thanks,

But I want this total in Dimension Column.

In dimension column,there is no expression.

Re: Total related problem in Column of Chart

Tue, 11 Jun 2013 05:40:07 GMT

For more Clarification

takes an example..

I have three dimension in pivote chart

Material Type

Material Code

Material Group

If I tick show partial subtotal for all three fields.

for Material Code, it takes subtotal of Material Type

for Material Group,it takes subtotal of Material Code

Thanks ....

Re: Total related problem in Column of Chart

Gysbert_Wassenaar — Tue, 11 Jun 2013 19:09:10 GMT

Well, I understand it can be a bit confusing, but the partial sum show the total of the column where you enable partial sums. So for the first dimension (the left-most column) it returns the chart total. For the second dimension it returns the total of that column for each value of the first dimension. So for the second dimension you see subtotals for each value of the first dimension. And so on for the other dimensions. When you think about it a bit you'll see that it actually makes sense. And that doing it differently wouldn't really work. You wouldn't be able to create an overall total and the right-most dimension couldn't have a partial sums option.