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 can I do ?

rownum month value1 value2

1 1 543 Null

2 2 550 550-543

3 3 560 560-550

4 4 558 558-560

.................

.

.

.

.

value2's value is got in this way:next row's value1's value-this row's value1's value.

How can I get the value in QV? what's the function?and can anyone give me a sample,thank you!

1 Reply
Miguel_Angel_Baeyens

Hello,

Assuming you are drawing a pivot table, that rownum and month are dimensions and value1 is an expression

Above(value1) - value1


Using inter record functions will give you what you want.

Hope this helps