Discussion Board for collaboration on QlikView Scripting.
I want to create a chart as per the below, I have the user, date and the volume per day.
But in the MTD column I need to have 61+71 in row 2 for example.
In row 3 its the sum of 71+61+75 and so on.
Is this possible?
I have tried above and below functions but cannot seem to achieve this.
Go to Solution.
=RangeSum( Above( Sum(VolumeField), 0, RowNo() ))
Or may be this:
=RangeSum(Above(TOTAL Sum(VolumeField), 0, RowNo(TOTAL)))
That's great, only thing is if I wanted it to reset at each new row fro example below;
Thanks again for your help
you can use the following expression in your query:
[Volume] + if(isnull(Peek(acc_volume, -1)), 0, Peek(acc_volume, -1)) as acc_volume
That's why I left out the TOTAL qualifier.
Perfect thank you