topic Re: Peek in QlikView

Peek

Mon, 14 Jul 2014 08:19:53 GMT

Hi Friends,

I have a small doubt in peek function. Please find the attached Excel & QVW. As per the attached excel I want to show the output in QVW. I can reach the output through If condition. But I want without if condition. please help me.

Re: Peek

lironbaram — Mon, 14 Jul 2014 08:30:12 GMT

hi have a look at the attach example

this is the script

DataTemp:

LOAD Name,

FROM

[peek test.xlsx]

(ooxml, embedded labels, table is Sheet1);

Data:

load *,

if(previous(Name)=Name,Peek(ID),0) as peekid

Resident DataTemp

Order by Name, ID;

drop Table DataTemp;

Re: Peek

alexandros17 — Mon, 14 Jul 2014 08:30:24 GMT

Simply do:

LOAD Name,

ID,

Peek_ID

FROM

(ooxml, embedded labels, table is Sheet1);

There is no need of peek function ...