topic Re: Partial Sum calculation in Pivot table in QlikView

Partial Sum calculation in Pivot table

Tue, 13 Jan 2015 12:08:34 GMT

Hi Team,

Here I have attached sample qvw.

My Requirement,

1. I need to convert negative numbers [sum(F1-F2)] to zero,for that purpose i have used Range max function

2. I have to calculate Partial sum,while calculating it takes the negative numbers too.But In straight table it is working perfectly

Could you help me to solve this issue.

Thanks in advance.

jonathandienst — Tue, 13 Jan 2015 12:12:34 GMT

Pivot table 'sum of rows':

=Sum(Aggr(RangeMax(sum(F1-F2), 0), F1, F2))

HTH

Jonathan

PrashantSangle — Tue, 13 Jan 2015 12:15:54 GMT

Hi,

Use Aggr()

Try like

SUM(aggr(IF(SUM(F1-F2)>0,SUM(F1-F2),0),F1,F2))

Regards,