topic Using calculated cell from above in App Development

Using calculated cell from above

Przemyslaw_Rybacki — Tue, 21 Sep 2021 18:33:31 GMT

Hey All!

I need your help with the data set (as an example I put it in excel):

What I need is to fetch during of calculation for field "Purge" the fileds above calculated (for example cell D10).

Is there function in Qlik Sense which let me to do it?

I know that above() works only in table/chart, but is there an option to do it in my script?

Re: Using calculated cell from above

stevejoyce — Tue, 21 Sep 2021 18:43:01 GMT

You can use peek() for this.

Re: Using calculated cell from above

Przemyslaw_Rybacki — Wed, 22 Sep 2021 06:33:44 GMT

When I do like this, result is null for field "Purge"

Test:

Load

Day

Stock

Inbound

(Stock-30-peek('Purge',-1)) as Purge

From.....

Re: Using calculated cell from above

stevejoyce — Wed, 22 Sep 2021 10:18:32 GMT

1) drop the single quotes.

2) you'll need to add if(rowno() = 1). Because row 1 returns null, and you can't subtracting null after that resulting in null. try this/update row1 as you need:

If(rowno() = 1, 0, (Stock-30-peek(Purge,-1)) ) as Purge

Re: Using calculated cell from above

Przemyslaw_Rybacki — Wed, 22 Sep 2021 10:39:38 GMT

It's working, Thanks a lot!