Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Pivot chart values aggregate

Hi all,

i have a pivot chart like this :

         

RolesSexN° Emp

A
Man2
Woman3

i need to trasform it in :

Header 1Header 2Header 3
AMan+woman5
Woman3

Can u help me pls?

tyvm

5 Replies
sushil353
Honored Contributor II

Re: Pivot chart values aggregate

Try using this expression:

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

HTH

Sushil

dfoster9
Valued Contributor

Re: Pivot chart values aggregate

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.

salto
Valued Contributor II

Re: Pivot chart values aggregate

Hi,

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

1.png

Not applicable

Re: Pivot chart values aggregate

Hi,

See the attached example.

Not applicable

Re: Pivot chart values aggregate

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

Community Browser