topic Re: Below function vs above function in QlikView

Below function vs above function

mgranillo — Wed, 25 Nov 2020 16:16:04 GMT

I have an issue with the above and below function.

Lets say i have the following table in a chart:

Date Value RowNo()

1/1/2017 4 1

1/2/2017 4 2

1/3/2017 7 3

1/4/2017 2 4

I can add another expression RangeMax(above(sum(value),0,rowno())) and this will return

Date Value RowNo() RangeMax(above(sum(value),0,rowno()))

1/1/2017 4 1 4

1/2/2017 4 2 4

1/3/2017 7 3 7

1/4/2017 2 4 7

Now I'd like to sort my table by descending date. What do I need to change in RangeMax(above(sum(value),0,rowno())) to keep the same results?

Is this something simple that I'm missing? I tried the below function but it doesn't work with how RowNo() works

Date Value RowNo() ?

1/4/2017 2 1 7

1/3/2017 7 2 7

1/2/2017 4 3 4

1/1/2017 4 4 4

mgranillo — Fri, 08 Sep 2017 21:36:14 GMT

Attaching sample Qlik Sense app

antoniotiman — Sat, 09 Sep 2017 07:48:20 GMT

Hi Michael,

maybe this

RangeMax(Bottom(Sum(Value),1,NoOfRows()-RowNo()+1))

Regards,

Antonio

effinty2112 — Sat, 09 Sep 2017 09:27:29 GMT

Hi Michael,

Try:

RangeMax(Below(sum(Value),0,NoOfRows()- RowNo()+1))

Cheers

Andrew

mgranillo — Mon, 11 Sep 2017 16:14:24 GMT

Both seem to work. Thanks for the help. Antonio's response came in first so marking his as correct