topic Re: Why Peek() don't work with Preceding Load? in QlikView

Why Peek() don't work with Preceding Load?

Mattia — Sat, 16 Nov 2024 01:52:51 GMT

Hi guys,

i'm in trouble because i notice that Peek() don't work with Preceding load and i don't know why.

Load
If(COUNT=Peek(COUNT),Peek(PROG)+1,1) as PROG,
*
Where Len(Trim(CODE))>0;

The output i want is the following: for every COUNT a numerical sequence (PROG) if the CODE>0.

Now, all the PROG=1.

What's my mistake?

Thanks,

Mattia

Re: Why Peek() don't work with Preceding Load?

Taoufiq_Zarra — Fri, 22 Nov 2019 14:20:45 GMT

Hi Mattia,

I didn't understand your question very well, maybe with an example I can understand it well.

otherwise Peek() in Qlik: finds the value of a field in a table for a row that has already been loaded or that exists in internal memory.

while in your function you use If(COUNT=Peek(COUNT),Peek(PROG)+1,1) as PROG

so you test on a value that is not yet loaded in memory "COUNT=Peek(COUNT)".

think about using "Resident".

I hope this will help you.

Taoufiq

Re: Why Peek() don't work with Preceding Load?

Stoyan_Terziev — Fri, 22 Nov 2019 14:22:21 GMT

Hi Mattia,

What you've written down is a code that identifies if the previous row is the same number.

For this to work properly, you may want to order your data by the column [COUNT] like this:

(script below is plug-and-play)

TestData: Load * INLINE [ COUNT 101 102 103 103 104 105 105 105 106 ]; Transformed: NoConcatenate Load If(COUNT=Peek(COUNT), Peek(PROG)+1,1) as PROG, COUNT Resident TestData ORDER BY COUNT ASC ; DROP TABLE TestData;

Results:

Keep in mind, if you only get 1's - you can check if you have only unique values in the column COUNT.

I hope that helps!

Kind regards,

S.T.

Re: Why Peek() don't work with Preceding Load?

Mattia — Fri, 22 Nov 2019 15:05:55 GMT

Hi guys and thanks for the suggests.

I'm sorry but i'm not able to solve this problem.

If you can, the original problem is the following:

https://community.qlik.com/t5/QlikView-Scripting/How-can-i-insert-this-expression-in-the-load/td-p/1649631

Please, help me!!!

Thanks,

Mattia

Re: Why Peek() don't work with Preceding Load?

Sue_Macaluso — Thu, 05 Dec 2019 21:45:47 GMT

@Mattia Hi, it seems the post your linking to has been deleted, please provide the needed details. Thank you