Previous Value in Straight Table

[Anonymous]

Hi All,

Please guide me how to get previous value in qlikview straight table.

Example

Two Order Number

Order Number

11111

22222

In Straight table i need to get 1111 value only

Thks

[#2]

hi,

use above and below function.check in help

Regards

Vimlesh

[#3]

Hi,

Use above(Order Number)

[sushil353]

Hi,

Not able to understand your issue.. where do you want to show this value..

if you want to do some calculation with previous value and current value then you can use Above() function.

HTH

Sushil

[Anonymous]

Hi All,

I have a chart where

Dealer Name ,  Vehicle No, Current Repair Order Number , Previous Repair Order No

A, TN 0006, 00001 , 00002

Basically they are comparing current repair order number and previous repair order number

Table has field named order number

Ordernumber

00001

00002

i want to get current value and previous value in straight table ...

Thks