topic Re: How to Get Previous Row Answer in QlikView

How to Get Previous Row Answer

Mon, 25 May 2015 07:48:54 GMT

Hi,

Im trying to get an answer for Previous Row Answer as below:

Numbers	Names
1234	A
1234	B
12354	C
12354	D
12543	E
1234	F
54321	G

The Previous im using its looking at the Previous Corresponding Same Number, so i need previous row

as like Current row is determined by the previous Row.

Re: How to Get Previous Row Answer

marcus_sommer — Mon, 25 May 2015 07:52:20 GMT

Have a look here: Peek() vs Previous() – When to Use Each.

- Marcus

Re: How to Get Previous Row Answer

Mon, 25 May 2015 08:04:16 GMT

Please supply sample example

Re: How to Get Previous Row Answer

marcus_sommer — Mon, 25 May 2015 08:11:19 GMT

It's something like this:

t1:

Load * From Source;

t2:

Load *, if(Numbers = peek('Numbers', -1), Then, Else) as NewField Resident t1 order by Numbers;

drop tables t1;

Important is to order the load within a resident load and then check the rows against each other. maybe you need to implement a few more check-logics (if's).

- Marcus

Re: How to Get Previous Row Answer

timanshu — Mon, 25 May 2015 08:15:42 GMT

In front end, Use Above function and for script use previous function

Re: How to Get Previous Row Answer

vishsaggi — Mon, 25 May 2015 08:18:29 GMT

Hi Thabiso,

Can you attach you sample .qvw file so that we can work on it.

Thanks,