topic Re: Total in pivot table in QlikView

Total in pivot table

francisvandergr — Tue, 21 Jun 2011 10:29:45 GMT

I have a formula in the expression of a pivot table :

The formula is: sum(Amount) / Price.

My problem is that i see no total at the top of the column. i have selected the option "subtotals on top" . I don't want a straight table of this. has anyone an idea ?

Total in pivot table

kaushiknsolanki — Tue, 21 Jun 2011 10:35:51 GMT

Its a pivot table. So to view total you have to select partial total checkbox. You will find that in Properties-> Presentation -> Click on the dimension for which you want total and click on Partial Total.

In same tab you can define the top or bottom position of total. From Subtotals on Top and Subtotals at Bottom

Regards,

Kaushik Solanki

Re: Total in pivot table

Tue, 21 Jun 2011 10:41:30 GMT

Hi,

You can have subtotals on top in a pivot table. Please see attached doc.

Regards

Arun

Re: Total in pivot table

francisvandergr — Tue, 21 Jun 2011 10:44:12 GMT

Sorry bu ti have already selected Partial Total on my dimension Article. For another expression "Amount it works". But nogt for this expression

Re: Total in pivot table

kaushiknsolanki — Tue, 21 Jun 2011 10:50:58 GMT

Have a look at this example. If this doent work send us your qvw file.

Regards,

Kaushik Solanki

Re: Total in pivot table

francisvandergr — Tue, 21 Jun 2011 10:58:03 GMT

Hereby i send you my qvw. The problem expression is the expression "Aantal"

Re: Total in pivot table

kaushiknsolanki — Tue, 21 Jun 2011 11:12:43 GMT

Hi,

Here is your solution.

Regards,

Kaushik Solanki

Re: Total in pivot table

francisvandergr — Tue, 21 Jun 2011 11:21:55 GMT

It is not the good value. The problem i see the not the result of the totals of the row. Fo rperiod 1 the total is about 128. Now i see 33.17

Re: Total in pivot table

Tue, 21 Jun 2011 11:22:59 GMT

try this one

Re: Total in pivot table

francisvandergr — Tue, 21 Jun 2011 11:51:31 GMT

Thnx indeed this is the solution. I understand!