Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
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
Luminary Alumni
Luminary Alumni

Hi,

     Try above([ValueCurrent])

     Have a look at the attachment.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

2 Replies
kaushiknsolanki
Luminary Alumni
Luminary Alumni

Hi,

     Try above([ValueCurrent])

     Have a look at the attachment.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

jagan
Luminary Alumni
Luminary Alumni

Hi,

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

Regards,

Jagan.