Discussion Board for collaboration on QlikView Scripting.
Here I have attached sample qvw.
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.
Go to Solution.
Pivot table 'sum of rows':
=Sum(Aggr(RangeMax(sum(F1-F2), 0), F1, F2))