topic Re: peek? in QlikView

peek?

Anonymous — Tue, 20 Jan 2015 12:34:09 GMT

Hi I HAVE TABLE LIKE

Products:

apple

banana

orange

mango

when i go for load into qlikview

table1:

load

products

from xl sheet; fine up to here

now if i go for peek here

table1:

load

products

peek('products',-1,'table1') as new

from xl sheet;

now i am getting in new field

new:

mango

my question is peek will use for only one value ?

i want in loop format like it has return apple,banana,mango,orange all how to do it ?

Re: peek?

giakoum — Tue, 20 Jan 2015 12:40:05 GMT

This works for me :

data:

LOAD * INLINE [

Products

apple

banana

orange

mango

];

table1:

load

Products,

peek('Products',-1) as new

Resident data;

Re: peek?

alexandros17 — Tue, 20 Jan 2015 12:40:06 GMT

The second parameter means: start from the end -1 so you have mango. If you use RowNo() instead of -1 the result should change

Re: peek?

francoiscave — Tue, 20 Jan 2015 12:44:39 GMT

Hi CommonQlik,

Use a function or a varible in the second parameter:

Random solution:

table1:

load

products

peek('products',Floor(rand()*4),'table1') as new /*There are 4 fruits in your table)*/

from xl sheet;

I search an Index solution...

François

Re: peek?

its_anandrjs — Tue, 20 Jan 2015 12:56:41 GMT

Hi,

You have to iterate the peek function from

table1:

LOAD * INLINE [

products

apple

banana

orange

mango

];

let vNoofRows = NoOfRows('table1');

Data:

LOAD

products,

peek('products',IterNo(),'table1') as new

FROM

[Data\Test.xlsx]

(ooxml, embedded labels, table is Sheet1) While IterNo() <= $(vNoofRows);

But you can use Mapping load here rather than peek if you have two fields.

Regards

Anand

Re: peek?

MarcoWedel — Tue, 20 Jan 2015 13:06:51 GMT

please define your expected result.

Re: peek?

marcus_malinow — Tue, 20 Jan 2015 13:13:51 GMT

I'm not sure that peek will give you your desired result.

How about

table1:

load

products

from xl sheet;

LEFT JOIN (table1)

LOAD concat(DISTINCT products, ',') as new

RESIDENT table1;

Re: peek?

Anonymous — Tue, 20 Jan 2015 13:53:23 GMT

here my doubt is

can we use peek in loaded table or

we need to take resident have to use ?

is it same for previous function ?

Re: peek?

Bill_Britt — Tue, 20 Jan 2015 13:58:15 GMT

Hi,

I would have to agree with Marco. What are you trying to do and what is the expected results. Peek is normally used to pull data from a certain row in a table.

Bill

Re: peek?

its_anandrjs — Tue, 20 Jan 2015 14:00:26 GMT

Hi,

Provide any sample data or expected output that what is your output then it will easy to understand the problem.

Regards

Anand

Re: peek?

richard_chilvers — Tue, 20 Jan 2015 14:04:06 GMT

Several seem to be agreed that it may not be a good solution. So if you share with us what you want to achieve, I'm sure we can come up with some new ideas.

Re: peek?

marcus_malinow — Tue, 20 Jan 2015 14:12:02 GMT

Ok, to solve the problem you posed, Peek and Previous are not the solution.

In answer to your question, they can both be used on an initial load from SQL or Excel or wherever. Or in a RESIDENT load.

Re: peek?

Anonymous — Tue, 20 Jan 2015 14:12:27 GMT

Hi i got answer from above reply

in the mean time i got more queries also

1)peek should used to get data for only one row or multiple rows generally

2)we can use in the same table or must and should we need to take resident of that table and have to write peek there?

3) in previous function how get data for multiple rows

4) if possible pls explain me clearly with some sample script using peek and previous ?

thank u very much in advance

Re: peek?

Anonymous — Tue, 20 Jan 2015 15:03:01 GMT

Hi try like this ,

i got near to your problem but one value (apple ) is missing .So if you got any idea please come up with a solution

data:

LOAD * INLINE [

Products

apple

banana

orange

mango

];

peek:

load Products ,

Peek(Products,RowNo(),'data') as peek2

Resident data

Thanks

Re: peek?

Anonymous — Tue, 20 Jan 2015 15:17:55 GMT

for prdoucts u should put in single quoates i guess

Re: peek?

Anonymous — Tue, 20 Jan 2015 15:20:11 GMT

THATS I UNDERSTOOD

because

recno and rowno start with value 1

but peek start with 0 so that first value is missing

can any one guide to get the first value also by using peek function?

Re: peek?

Tue, 20 Jan 2015 15:26:47 GMT

u will get now try this

Peek(Products,RowNo()-1,'data') as peek2

Re: peek?

Anonymous — Tue, 20 Jan 2015 15:35:22 GMT

one more doubt

previous(Products) if i go with this then it is ignoring last record it means 4 th record why?

how to get 4th record or previous will not give last record?

Re: peek?

Anonymous — Tue, 20 Jan 2015 15:50:56 GMT

great work manojqlik

Re: peek?

its_anandrjs — Tue, 20 Jan 2015 16:44:11 GMT

Hi,

You can use

Peek('products',IterNo() - 1,'table1') as New

Regards,

Anand