topic Above() or below() functions in QlikView

Above() or below() functions

Mon, 09 Nov 2015 10:45:22 GMT

Hi there

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.

Thanks,

Aidan

swuehl — Mon, 09 Nov 2015 12:35:39 GMT

Try with

=RangeSum( Above( Sum(VolumeField), 0, RowNo() ))

sunny_talwar — Mon, 09 Nov 2015 12:38:51 GMT

Or may be this:

=RangeSum(Above(TOTAL Sum(VolumeField), 0, RowNo(TOTAL)))

Mon, 09 Nov 2015 14:45:12 GMT

Hi Sunny

That's great, only thing is if I wanted it to reset at each new row fro example below;

Thanks again for your help

AIdan

Anonymous — Mon, 09 Nov 2015 15:46:07 GMT

Hi,

you can use the following expression in your query:

LOAD ...

[Volume] + if(isnull(Peek(acc_volume, -1)), 0, Peek(acc_volume, -1)) as acc_volume

from ...;

swuehl — Mon, 09 Nov 2015 16:00:14 GMT

That's why I left out the TOTAL qualifier.

Mon, 09 Nov 2015 16:02:17 GMT

Perfect thank you