topic Re: Add total for dimension in table in QlikView

Add total for dimension in table

Thu, 03 Apr 2014 19:12:50 GMT

Hi,

Say I have a data structure that looks like:

Load * Inline

[

Client,Spend,Receive,From

A,2,5,D

A,4,5,D

A,1,7,D

A,2,6,E

A,4,7,E

A,1,2,E

B,2,2,D

B,1,4,D

B,5,7,D

B,2,6,E

B,1,7,E

B,5,7,E

C,3,4,D

C,8,9,D

C,7,3,D

C,3,5,E

C,8,6,E

C,7,1,E];

And I have a pivot table with dimensions Client and Spend and expression Sum(Receive). At the bottom of the chart I want to show a total for Spend. Is this possible? And, if so, how can I do it?

I've attached an example to help illustrate my question.

Thanks and best,

Ryan

Re: Add total for dimension in table

chiru_thota — Thu, 03 Apr 2014 19:38:42 GMT

As per as I know it is difficult to do that.

I tried different approach by taking two objects. Have a look and see if you can do the same.

(1) Pivot table for showing data

(2) Straight table to show the total at bottom.

Basically you need cover bottom report with top by using layout --> Layer

Re: Add total for dimension in table

Thu, 03 Apr 2014 20:12:54 GMT

Hello,

sory, but my license ended

Do you expect 33 or rather 66 as sum of Spend?

regards

Darek

Re: Add total for dimension in table

Thu, 03 Apr 2014 20:15:23 GMT

Re: Re: Add total for dimension in table

Thu, 03 Apr 2014 20:30:37 GMT

No ideal ....

It is also possible to have it in 'Spend' Label field.

But to have it under Spend dimension column, i think only chiru.thota solution will work

Unfortunetely it may be difficult if your user would like to resize or move pivot ....