topic Re: Help in Peek Function in QlikView

Help in Peek Function

vikasshana — Sat, 16 Nov 2024 00:18:35 GMT

Hi,

I need help in getting the last row using peek function and below is the sample data.

PeekTest:
LOAD * Inline
[
ID
1
2
3
];

LOAD ID,
Peek(ID,0) as FirstValue
Resident Peek;

By using the above peek function i can able to get the first row into FirstValue field i,e, '1' but when i use 'Peek(ID,-1) as LastValue' i'm getting '1' and '2' but i want to see only '3'.

Can someone help me to identify the issue.

Regards,

Bharath Vikas

Re: Help in Peek Function

sunny_talwar — Thu, 16 Jul 2020 13:34:35 GMT

You want to see just one row with 3 or are you looking to see all three rows with 3 in it?

Re: Help in Peek Function

Frank_Hartmann — Thu, 16 Jul 2020 13:43:13 GMT

PeekTest: LOAD * Inline [ ID 1 2 3 ]; NoConcatenate Final: Load * Resident PeekTest Order by ID desc; LOAD ID, Peek(ID,0) as FirstValue Resident Final;

Re: Help in Peek Function

vikasshana — Thu, 16 Jul 2020 14:13:19 GMT

@sunny_talwar I want to see one row with 3.

Re: Help in Peek Function

vikasshana — Thu, 16 Jul 2020 14:19:12 GMT

@Frank_Hartmann thanks for that, but my requirement is I want first value and last value. It means if i use 'Peek(ID,0) as FirstValue' i want the result as '1' as below

FirstValue

And if i use 'Peek(ID,-1) as LastValue' i want the result as '3' as below

LastValue

Re: Help in Peek Function

sunny_talwar — Thu, 16 Jul 2020 18:50:27 GMT

Do you need Peek() or can this work instead?

Test: LOAD LastValue(ID) as LastValue; LOAD * INLINE [ ID 1 2 3 ];

Re: Help in Peek Function

vikasshana — Fri, 17 Jul 2020 10:46:12 GMT

@sunny_talwar thanks for that, it works for me and i've modified the script a little bit as below in order to get the firstvalue as well.

Test:
LOAD LastValue(ID) as LastValue, FirstValue(ID) as FirstValue;
LOAD * INLINE [
ID
1
2
3
4
];