topic Re: Pivot chart values aggregate in QlikView

Pivot chart values aggregate

Thu, 24 Oct 2013 09:10:45 GMT

Hi all,

i have a pivot chart like this :

Roles	Sex	N° Emp
A	Man	2
A	Woman	3

i need to trasform it in :

Header 1	Header 2	Header 3
A	Man+woman	5
A	Woman	3

Can u help me pls?

tyvm

Re: Pivot chart values aggregate

sushil353 — Thu, 24 Oct 2013 09:17:48 GMT

Try using this expression:

rangesum(Below(sum(temp),0,RowNo()+1))

HTH

Sushil

Re: Pivot chart values aggregate

DavidFoster1 — Thu, 24 Oct 2013 09:20:11 GMT

I dont think you can do this directly in the pivot table. You will need to change the data model to derive what would be a need value for the Gender dimension.

Re: Pivot chart values aggregate

salto — Thu, 24 Oct 2013 09:29:50 GMT

Hi,

what about adding "Show partial sums" to the pivot table?

Re: Pivot chart values aggregate

Thu, 24 Oct 2013 09:33:53 GMT

Hi,

See the attached example.

Re: Pivot chart values aggregate

Thu, 24 Oct 2013 09:35:51 GMT

I have to show without partial sum row, but it could be right.

Can i use the value of partial sum in other char? can i save it in a variable?

tyvm