Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hi

what is the difference between pick function and peek function?

3 Replies
its_anandrjs
Champion III
Champion III

Hi,

Both are using different ways

Pick:-

If the given value match in the column it will return the column value in the below Pick 2 will return corresponding value B in the field Selection.

LOAD ColA,ColB,Pick(2,'A','B','C') AS Selection;

LOAD * Inline

[

ColA,ColB

A,1

B,2

C,3

];

Peek:-

It will return the specific value in the field of the table from any given position suppose in the column ColB need to peek last value

LET vLastValue = Peek('ColB',-1,'Table1');

Then it will return 3.

Reagrds

Anand

vardhancse
Specialist III
Specialist III

Pick:

pick(n, expr1[ , expr2,...exprN])

Returns the n:th expression in the list. n is an integer between 1 and N.

Example:

pick( N'A''B'4, , , )

returns 'B' if N = 2

returns 4 if N = 3


Peek:


peek(fieldname [ , row [ , tablename ] ] )

Returns the contents of the fieldname in the record specified by row in the internal table tablename. Data are fetched from the associative QlikView database.

Fieldname must be given as a string (e.g. a quoted literal).

Row must be an integer. 0 denotes the first record, 1 the second and so on. Negative numbers indicate order from the end of the table. -1 denotes the last record read.

If no row is stated, -1 is assumed.

Tablename is a table label, see Table Labels, without the ending colon. If no tablename is stated, the current table is assumed. If used outside the load statement or referring to another table, the tablename must be included.

Examples:

peek( 'Sales' )
returns the value of Sales in the previous record read ( equivalent to previous(Sales) ).

peek( 'Sales', 2 )
returns the value of Sales from the third record read from the current internal table.

peek( 'Sales', -2 )
returns the value of Sales from the second last record read into the current internal table.

peek( 'Sales', 0, 'Tab1' )
returns the value of Sales from the first record read into the input table labeled Tab1.

Load A, B, numsum( B, peek( 'Bsum' ) ) as Bsum...;
creates an accumulation of B in Bsum.

Not applicable
Author

Hi Madhu,

Please refer below link, this will be helpful.

http://community.qlik.com/thread/106578

Regards,

Lalit