topic Re: Multiple pick statements in Expressions in QlikView

Multiple pick statements in Expressions

naveenchellaara — Sun, 24 Feb 2013 03:57:06 GMT

Is it possible to give multiple pick statements in an expression?

I need to achieve the folowing

pick(match(Var1,255,100,150,170,200),$(ColourCode1),$(ColourCode2),$(ColourCode3),$(ColourCode4),$(ColourCode5))

pick(match(Var2,255,100,150,170,200),$(ColourCode1),$(ColourCode2),$(ColourCode3),$(ColourCode4),$(ColourCode5))

pick(match(Var3,255,100,150,170,200),$(ColourCode1),$(ColourCode2),$(ColourCode3),$(ColourCode4),$(ColourCode5))

pick(match(Var4,255,100,150,170,200),$(ColourCode1),$(ColourCode2),$(ColourCode3),$(ColourCode4),$(ColourCode5))

pick(match(Var5,255,100,150,170,200),$(ColourCode1),$(ColourCode2),$(ColourCode3),$(ColourCode4),$(ColourCode5))

Can some one help me with this?

Re: Multiple pick statements in Expressions

Sun, 24 Feb 2013 14:52:12 GMT

What is the objective for your expression? You list several expressions that are valid, but what is it you want to accomplish or return from your expression?

Re: Multiple pick statements in Expressions

naveenchellaara — Tue, 26 Feb 2013 12:41:37 GMT

I need to achieve all these in a single expression... all statements are valid..

Re: Multiple pick statements in Expressions

Wed, 27 Feb 2013 00:50:52 GMT

You offer 5 different expressions, each taking a different variable, each returning a color code based on that variable. I don't follow how you want to combine these into a single expression. What would the expression return?

Are you saying you want to evaluate the first pick, return a color code if Var1 matches one of the values supplied, otherwise evaluate the next pick, and so on?

Re: Multiple pick statements in Expressions

naveenchellaara — Wed, 27 Feb 2013 06:13:26 GMT

Yes. That exactly what i am trying to get to.

Re: Multiple pick statements in Expressions

swuehl — Wed, 27 Feb 2013 09:13:54 GMT

Have you tried the alt() function to do this?

=alt(exp1,exp2,exp3,exp4,exp5)

exp being your expressions.

Re: Multiple pick statements in Expressions

Anonymous — Wed, 06 Dec 2017 07:27:31 GMT

Hi im trying to have 2 dimensions on the alt () using pick match expression as well to go along with the colour code. Is there any way to input this codes ?

eg:

alt(pick(match(StatusDescription,'good','bad','neutral'),red(),lightblue(),LightGreen()),

pick(match(Food,'Chicken rice','Fried rice','Muffins'),lightred(),blue(),LightGreen()))

Than You

Joanna Christine

Re: Multiple pick statements in Expressions

swuehl — Wed, 06 Dec 2017 13:21:13 GMT

Could you upload a small sample QVW with some sample records and your current UI object?