topic AW:Problem with Peek() in QlikView

Problem with Peek()

Fri, 25 Feb 2011 10:49:06 GMT

For comparison I need the previous values from 2 fields, but for some reason, peek() and previous() always take the values from the current row, not the previous row:

[Verfahren/Teilverfahren]:
load
Object_ID,
Verfahren,
peek('Verfahren') as Verfahren_Previous,
peek('Object_ID') as ID_Previous
resident Teilverfahren;

Results in:

Any ideas??

Problem with Peek()

maneshkhottcpl — Fri, 25 Feb 2011 10:59:02 GMT

Use

peek(recno()<=2,'',peek(ID_Previous,recno()-2)) as FieldName

Problem with Peek()

Fri, 25 Feb 2011 11:35:16 GMT

Hi Manesh,

thanks for your reply, unfortunately this is not working, because recno() counts records for each object_id (I don't know why this happens):

I think that may be the reason why peek() and previous() fails...

Do you know any solution for this?

Thanks in advance!

AW:Problem with Peek()

Fri, 25 Feb 2011 11:44:47 GMT

Hallo Eva,

couldn't believe that your posted script code doesn't work as expected. For that reason I tried it for my own. And it works fine. Take a look at my little exam app. So what are the differences to your app?

Regards, Roland

Problem with Peek()

Fri, 25 Feb 2011 11:45:27 GMT

try rowno() instead of recno()....

AW:Problem with Peek()

Fri, 25 Feb 2011 14:10:10 GMT

Hi Roland,

the reason must be something with my data-model... I am reading the data from an xml-files and there could be multiple values for one attribute. So QlikView groups the data after the attribute "object_id", so I can only adress the previous rows within that group, that's what I found out so far.