partial sum problem in pivot

Tue, 18 Nov 2014 07:46:25 GMT

Hi Guys,

Need ur help

Cash App Executive	Allocation_Status	11/17/2014
Anita Gupta	Closed	80
Anita Gupta	Reject	22
Anita Gupta	WIP	16
Anita Gupta	Total	89
Deepti.gokhale	Closed	37
Deepti.gokhale	Reject	23
Deepti.gokhale	Total	37
snehal.patil	Closed	72
snehal.patil	Reject	23
snehal.patil	WIP	9
snehal.patil	Total	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

Re: partial sum problem in pivot

lironbaram — Tue, 18 Nov 2014 07:55:55 GMT

have a look at the attach example

i used aggr function !

topic partial sum problem in pivot in QlikView

partial sum problem in pivot

Re: partial sum problem in pivot