topic Re: can any one explain pick and match function in QlikView

can any one explain pick and match function

honeyasha — Wed, 25 Nov 2020 16:16:04 GMT

Please explain pick and match function with example and in which scenario we will use this.

Re: can any one explain pick and match function

Anonymous — Mon, 03 Sep 2018 17:36:58 GMT

Pick

It is a conditional statement that will perform certain action based on the result of the condition.

Syntax: Pick(condition, exp1, exp2, ....expN)

So if condition=1 exp1 will be performed.

if condition=2 exp2 will be performed and so on

Match

Match function will compare the string with the expression and returns the number(position) of the expression that matches.

Syntax: Match(String, exp1,exp2, ... expN)

Eg: Match(Month, April, July, Dec, Jan, Jun, Feb, Nov, Mar, Oct, May, Sep, Aug)

Result: if Month = March the result will be 8

Month = August the result will be 12 and so on

Re: can any one explain pick and match function

MarcoWedel — Mon, 03 Sep 2018 22:20:14 GMT

did you already try help?

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ConditionalFunctions/pick.htm

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ConditionalFunctions/match.htm

Re: can any one explain pick and match function

Anonymous — Tue, 04 Sep 2018 05:22:38 GMT

Pick: This Function is used On Script level and in front end i.e on chart level .

This function returns the nth expression in the list

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

Example: pick(N,'A','B,9,'D',5) If we specify the Value of N as 2 Then it will return 'B'

if we specify the value of N=3 then it will return 9 .

Match: As the name suggest Match is also an script level as well as front end i.e chart level function

This function is case sensitive and compares the value of first parameter with all the parameters and returns the number of expression that matches.

Syntax: match( str, expr1 [ , expr2,...exprN ])

Example: match(N,'ASIA','EUROPE','MEA','UNITED STATES')

If N= 'ASIA' it will return 1 and

If N='Australia' will return 0 as the string doesnt match .

Thanks

Re: can any one explain pick and match function

Anonymous — Tue, 04 Sep 2018 05:30:32 GMT

Hi,

pick - script and chart function

The pick function returns the n:th expression in the list.

Syntax:

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

Arguments:

Argument	Description
n	n is an integer between 1 and N.

Example	Result
pick( N, 'A','B',4, 6 )	returns 'B' if N = 2 returns 4 if N = 3

match - script and chart function

The match function compares the first parameter with all the following ones and returns the number of the expression that matches. The comparison is case sensitive.

Syntax:

match( str, expr1 [ , expr2,...exprN ])

Example	Result
match( M, 'Jan','Feb','Mar')	returns 2 if M = Feb. returns 0 if M = Apr or jan.

Example

Result

match( M, 'Jan','Feb','Mar')

returns 2 if M = Feb.

returns 0 if M = Apr or jan.

Re: can any one explain pick and match function

ecolomer — Tue, 04 Sep 2018 05:46:16 GMT

Hi,

Here you have an example