topic Re: Partial Sum is showing incorrect in pivot table in QlikView

Partial Sum is showing incorrect in pivot table

kapil_rthr — Tue, 05 Nov 2019 16:32:24 GMT

Not able to understand why the partial sum is showing incorrectly in the attached figure where as the sum of the productivity column for user 1 should be 66 but its showing wrongly as 58.

Re: Partial Sum is showing incorrect in pivot table

sunny_talwar — Tue, 05 Nov 2019 16:50:53 GMT

Try this

RangeSum( Count(DISTINCT {<SEVERITY = {'Blocker'}>} ISSUE_KEY) * 4, Count(DISTINCT {<SEVERITY = {'Major'}>} ISSUE_KEY) * 3, Count(DISTINCT {<SEVERITY -= {'Blocker', 'Major'}>} ISSUE_KEY) * 2 )

or you can try this

Sum(Aggr( If(SEVERITY = 'Blocker', Count(DISTINCT ISSUE_KEY) * 4, If(SEVERITY = 'Major', Count(DISTINCT ISSUE_KEY) * 3, Count(DISTINCT ISSUE_KEY) * 2)) , ASSIGNEE, SEVERITY))

Re: Partial Sum is showing incorrect in pivot table

kapil_rthr — Wed, 06 Nov 2019 03:31:59 GMT

awesome, it worked. thanks a lot.