topic Get previous value in App Development

Get previous value

power21 — Sat, 16 Nov 2024 19:20:07 GMT

Hello everyone

I am trying to create the same table as shown below in qliksense but i don't know how to get the second column.

As you can see the second column is calculated from the last one the issue is i don't know how to get the values from the last column et put it in the second one. also the yellow value is independent and the grey value is the sum of the second et the fifth column

i used this function to get the second column but the issue is i can ' t insert the yellow value, the yellow value is always equal to zero

This is what i am trying but as I said it always put a 0 in the yellow section is there any solution?

rangesum(above(Sum(Montant))

Re: Get previous value

Stoyan_Terziev — Thu, 09 Jan 2020 15:41:53 GMT

Hi,

How is your data filtered down to 2020 only? I suppose you are using a filter of some sort (year probably) and that's what applies the limitation on your data set. I guess the yellow value should be the value of 31st of Dec 2019.

The Above/Below functions only work on top of the chart prefiltered by your selections.

You need to do this on the back-end.

There is a way to do it on the front-end but it's crazy difficult and maintenance will be hell.

I hope that helps!

Kind regards,

S.T.

Re: Get previous value

power21 — Thu, 09 Jan 2020 16:03:04 GMT

Hello Stoyan,

This is just an example, not real data. I want to have the same result as shown in the picture using qlik sense but when using the above function i get a zero in the first row instead i want to have a exact value here for example i have the yellow value

Re: Get previous value

rwunderlich — Thu, 09 Jan 2020 22:43:09 GMT

I think:

Alt(rangesum(above(Sum(Montant)), Sum(Montant))

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com