topic Re: what is pick function in QlikView

what is pick function

gkcchowdary — Wed, 22 Jul 2015 07:54:33 GMT

Hi tell me pick function with example ,I know qlik view help,I what another example

Re: what is pick function

sushil353 — Wed, 22 Jul 2015 07:59:55 GMT

Powerful Pick Function in QlikView « Learn Qlikview

Re: what is pick function

Wed, 22 Jul 2015 08:01:30 GMT

There is a really useful ability on the community called 'search'. If you use this you'll find a number of threads already created on the subject.

Re: what is pick function

Wed, 22 Jul 2015 08:04:08 GMT

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.

Missing Manual - Peek()

Re: what is pick function

Wed, 22 Jul 2015 08:12:27 GMT

Hi Use this Code:

PEEK_TABLE:

LOAD KEY,Quantity,Peek(Quantity) as Previous_Quantity INLINE [

KEY , Quantity

1, 15

2, 25

3, 35

4, 45

5, 55

];

Re: what is pick function

Wed, 22 Jul 2015 09:04:50 GMT

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

if u want information about function in personal edition click on help section ->usinghelp -> index -> type what u want serch

Re: what is pick function

jagan — Wed, 22 Jul 2015 09:29:10 GMT

Hi,

Pick() will return the value in the given position. For example

=Pick(Ceil(Month(Today())/3), 'Q1', 'Q2', 'Q3', 'Q4')

Today is 7th month so Ceil(Month(Today())/3) will return 3 so it returns Q3.

Hope this helps you

Regards,

jagan.

Re: what is pick function

Siva_Sankar — Wed, 22 Jul 2015 09:49:37 GMT

A simple Example:

You have two expressions say eg: (3+5) and (1+2) and you want to pick 1 expression as output, you can use pick function here by mentioning which expression you want as output.

refer the screenshot below.

if you use =Pick(1, (3+5),(1+2)) then the first expression will be the output.

Re: what is pick function

Siva_Sankar — Wed, 22 Jul 2015 09:50:02 GMT

Re: what is pick function

Siva_Sankar — Wed, 22 Jul 2015 09:50:57 GMT

If you want more explanation watch this video..Pick Function in QlikView - YouTube