How to use Peek function?

[#1]

hi,

I do not know peek function ,how to use  that function please explain me with example.about peek function.

                               Thankyou,

Regards:

Madhu.

[sureshbaabu]

Hello,

Peek function returns the value of the previous record read.

For eg; In the output below,

• Name and Value are my source columns
• Expression for the other two:

     Peek('Value') as Peek_Value     

       – Stores the previous record value (this is same as Previous function)

     Peek('Value',1) as Peek_Value_1

     – Qlikview internally assigns values starting from ‘0’ ( ‘0’for the first row/record, ‘1’ for        the second row and so on).

       So, if we set the value as ‘1’. It reads the value at 2^nd row and starts assigning the same        value from 3rd row

Name	Value	Peek_Value	Peek_Value_1
A	1	-	-
B	2	1	-
C	3	2	2
D	4	3	2
E	5	4	2
F	6	5	2

For More clarity & real time example, Please take a look at the document on

Peek() vs Previous() – When to Use Each

Hope this helps!!

Thanks

[its_anandrjs]

Read some of the best documents with examples also.

Using Peek and Previous Functions Recursively to Help Transform Data

Peek() vs Previous() – When to Use Each

Hope this helps