topic Re: Help with Pick() function in QlikView

Help with Pick() function

Joaquin_Lazaro — Fri, 16 Oct 2015 09:12:31 GMT

Hello:

I have this expression in a chart: Pick(Month(Today()), 'Ene', 'Feb', 'Mar', 'Abr', 'May', 'Jun', 'Jul', 'Ago', 'Sep', 'Oct', 'Nov', 'Dic' )

I would like something like this

vMonth = 'Ene, Feb, Mar, Abr, May, Jun, Jul, Ago, Sep, Oct, Nov, Dic'

Pick(Month(Today()), vMonth)

But I can't get it. Is it possible ?

Thank you very much

Joaquín

Re: Help with Pick() function

miguelbraga — Fri, 16 Oct 2015 09:16:15 GMT

Hi Joaquin

Please try change your expression to this:

Pick(Month(Today()), $(vMonth) )

Re: Help with Pick() function

Joaquin_Lazaro — Fri, 16 Oct 2015 09:22:16 GMT

Hi Miguel:

I've just tried it, but it doesn't work

= Pick(Month(Today()), $(vMonth) ) it should be 'Oct' but the result in NULL !!!!

Thank you

Joaquín

Re: Help with Pick() function

SreeniJD — Fri, 16 Oct 2015 09:23:54 GMT

If you want to fetch the value from your variable, you have to use "$"

As suggested by MiguelBraga‌ have $(vMonth)

Re: Help with Pick() function

Joaquin_Lazaro — Fri, 16 Oct 2015 09:27:11 GMT

Sure, but it doesn't work !!!!

Re: Help with Pick() function

tresB — Fri, 16 Oct 2015 09:29:09 GMT

Define vMonth like:

'Ene', 'Feb', 'Mar',....... // No '=' sign and with closing quotes

Re: Help with Pick() function

tamilarasu — Fri, 16 Oct 2015 09:33:16 GMT

Hi Joaquin,

Change the variable vMonth Format like below,

'Ene', 'Feb', 'Mar', 'Abr', 'May', 'Jun', 'Jul', 'Ago', 'Sep', 'Oct', 'Nov', 'Dic'

Expression as Pick(Month(Today()), $(vMonth) )

It should work. Let me know.

Re: Help with Pick() function

Joaquin_Lazaro — Fri, 16 Oct 2015 09:39:13 GMT

Thank you guys. Now it works

Before write here I tried with vMonth and $(vMonth) ... but I didn't populate vMonth as tresesco and TamilArasu wrote because the expression editor mark it as error (red underline) !!!!

Good job, thanks you all

Joaquín