topic Re: Sum columns pivot table in QlikView

Sum columns pivot table

oboute — Wed, 25 May 2016 07:35:51 GMT

Hello

I have a pivot table with hours of work by employee and by type of hour (project, workorder ...)

So I have

In dimensions :
- employee name
- type of hours
In expression :
- Sum(Quantity)
In presentation tab :
- show partial sums

I would like a last column with total, for example here 42,20 + 430 + ... + 542,60 = 17145,8

When i try to add an expression with Sum(Total Quantity), the column is displaying for each type of hours :

How to do to have only one column at the end ?

Thanks in advance

Re: Sum columns pivot table

marcus_sommer — Wed, 25 May 2016 07:58:42 GMT

Within the presentation (top left) you could enable partial sums for each dimension separately.

- Marcus

Re: Sum columns pivot table

Anil_Babu_Samineni — Wed, 25 May 2016 08:00:44 GMT

Can i know, Where do you fetch from the Raw Data ?

Re: Sum columns pivot table

oboute — Wed, 25 May 2016 08:17:04 GMT

Hello,

I can't, it's in grey for my totals :

Re: Sum columns pivot table

PrashantSangle — Wed, 25 May 2016 08:29:12 GMT

Hi,

Presentation > select dimension > check show partial sum.

Regards

Re: Sum columns pivot table

oboute — Wed, 25 May 2016 08:35:21 GMT

Hello, as well as i answer to Marcus, it's in grey i can't check...

Re: Sum columns pivot table

marcus_sommer — Wed, 25 May 2016 11:32:07 GMT

The partial sums will be enabled on the dimensions and not on the expression and will by default use for the total the same expression - I think you should simply try it.

- Marcus

Re: Sum columns pivot table

oboute — Thu, 26 May 2016 08:12:20 GMT

It's Ok thank you !!!

I checked partial sum on the dimension, on the presentation tab :