Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

partial sum problem in pivot

Hi Guys,

Need ur help

Cash App ExecutiveAllocation_Status 11/17/2014
Anita GuptaClosed 80
Anita GuptaReject 22
Anita GuptaWIP 16
Anita GuptaTotal 89
Deepti.gokhaleClosed 37
Deepti.gokhaleReject 23
Deepti.gokhaleTotal 37
snehal.patilClosed 72
snehal.patilReject 23
snehal.patilWIP 9
snehal.patilTotal 79
Total 205

i'm having pivot table where i'm having expression as count(distinct allocation id) which you can see in  date column when i'm applying partial sum total for eas cash app executive it is showing wrong.for more clarification .PFA attached qvw

1 Reply
Honored Contributor II

Re: partial sum problem in pivot


have a look at the attach example

i used aggr function !