Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get previous value on straight table?

Hi, I'm trying to get the previous value in a straight table.

Basically here is the table example:

PeriodValueExpected value
Jan-12100
Feb-12200100Value of January
Mar-12300200
Apr-12400300
May-12200400
Jun-12100200
Jul-12100100
Aug-1290100

I wanted to do it in the chart expression. Attached it is the QV as example

I have tried already the Before function, without sucess.

So, if somebody could help I really appreciate.

Thanks in advance, Leandro

1 Solution

Accepted Solutions
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Try above([ValueCurrent])

     Have a look at the attachment.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

2 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

     Try above([ValueCurrent])

     Have a look at the attachment.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
jagan
Luminary Alumni
Luminary Alumni

Hi,

You can use Above(), to get the value of previous row in a straight table.

Regards,

Jagan.