How can I do ?

Tue, 23 Nov 2010 08:49:45 GMT

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!

Miguel_Angel_Baeyens — Tue, 23 Nov 2010 09:01:12 GMT

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

topic How can I do ? in QlikView