Discussion Board for collaboration related to QlikView App Development.
I have below data. Column 5 is the expected value required.
I tried using RangeSum it is not working.
Dimension: Column 1-4
Expression 1: Sum(Value)
Expression 2: RangeSum(Above(Total Sum(Value),0,RowNo(TOTAL)))
Can some please help.
Solved! Go to Solution.
Hi, I spotted the difference, now I have the same doubt as Manish, why that 15? shouldn't be '6' (it's a new country so it starts again)?
I attach a new document with this behaviour, I used a hidden column to calculate how many rows of the same country has to sum the above() function.
(html, codepage is 1252, embedded labels, table is @1);
If(Peek(Country)=Country,PEEK('Value'),0)+Value as Value
Resident a Order by Country;
Drop Table a;