topic Re: How to use PICK() IN QlikView? in QlikView

How to use PICK() IN QlikView?

Mon, 15 Dec 2014 13:55:36 GMT

for example for 1,2,3,4 -red

5,6,78-green

11,12,14-black

Re: How to use PICK() IN QlikView?

anbu1984 — Mon, 15 Dec 2014 13:59:33 GMT

=Pick(If(Field<=4,1,If(Field<=8,2,If(Field>=11 And Field <=14,3))),Red(),Green(),Black())

Re: How to use PICK() IN QlikView?

its_anandrjs — Mon, 15 Dec 2014 13:59:37 GMT

Can you elaborate more about this.

Regards

Anand

Re: How to use PICK() IN QlikView?

Anonymous — Mon, 15 Dec 2014 14:01:45 GMT

Hi,

See this post:

http://community.qlik.com/message/39553#39553

Regards

Neetha

Re: How to use PICK() IN QlikView?

german_avanzato — Mon, 15 Dec 2014 14:11:21 GMT

Hi,

Can elaborate a little more your Question?

Pick is used to retrieve the N value from the expression:

Pick ( N, 'A','B','C') will return 'C' with N = 3

N must be a value between 1 and infinity

You can use the help for more information.

Re: How to use PICK() IN QlikView?

Anonymous — Mon, 15 Dec 2014 14:18:33 GMT

Hi,

Use Pick and Match Function:

pick(match(status, 'G', 'A', 'R'), 'Green', 'Amber', 'Red','Grey')

Regards

neetha

Re: How to use PICK() IN QlikView?

its_anandrjs — Mon, 15 Dec 2014 15:09:13 GMT

Hi,

Please elaborate more or provide data or you can assume this small example

Raw:

LOAD * Inline [

Field

14 ];

New:

LOAD

Field,

Pick(if(Field <= 4,1,

if(Field > 4 and Field <= 8,2,

if(Field >= 11 and Field <= 14,3))),Red(),Green(),Black()) as Color

Resident Raw;

DROP Table Raw;

And then in the charts you can use this field Color as the Background color change.

Regards,

Anand