topic Re: Previous Value in Straight Table in QlikView

Previous Value in Straight Table

Anonymous — Wed, 25 Mar 2015 06:07:18 GMT

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

Wed, 25 Mar 2015 06:11:03 GMT

hi,

use above and below function.check in help

Regards

Vimlesh

Wed, 25 Mar 2015 06:11:04 GMT

Hi,

Use above(Order Number)

sushil353 — Wed, 25 Mar 2015 06:11:38 GMT

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 — Wed, 25 Mar 2015 10:43:41 GMT

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