topic Re: pick and match with variable in QlikView

pick and match with variable

bharath28 — Tue, 28 Jul 2015 11:56:18 GMT

Hi Experts,

I am using match function to expand a variable in 2nd parameter and give the position and the pick function to expand and return the result of the variable.

='Sales by ' & Pick(match(GetCurrentField([Group]),'No','=''$(vProdAlias)'''),'No1','=''$(vProdAlias)''')

Thanks!

Re: pick and match with variable

jonathandienst — Tue, 28 Jul 2015 12:00:31 GMT

This should do it:

='Sales by ' & Pick(Match(GetCurrentField([Group]), 'No', '$(vProdAlias)'), 'No1', '$(vProdAlias)')

Re: pick and match with variable

bharath28 — Tue, 28 Jul 2015 12:17:45 GMT

Hi Jonathan,

Thanks for the reply. However the expression is still not working.

Could you please use the app

Re: pick and match with variable

sunny_talwar — Tue, 28 Jul 2015 12:31:56 GMT

Try this expression:

='Sales by ' & Pick(Match(vGroup, 'No', '=' & Chr(39) & chr(36) & '(vProdAlias)' & Chr(39)),'No', vProdAlias)

Re: pick and match with variable

bharath28 — Tue, 28 Jul 2015 13:35:06 GMT

Thanks a lot Sunny! It is working

Just to have a better understanding could you please tell me why chr().

I understand that we have to store ='$(vProdAlias)' as string. But why it doesnt work with escape characters-

'=''$''(vProdAlias)'''''

But it works with your solution(with chr())??

'=' & Chr(39) & chr(36) & '(vProdAlias)' & Chr(39)

Re: pick and match with variable

sunny_talwar — Tue, 28 Jul 2015 15:42:08 GMT

Chr(36) is a dollar sign which doesn't get evaluated, but $ this gets evaluated. That's the way it works, don't really know why though

Best,

Sunny

Re: pick and match with variable

bharath28 — Tue, 28 Jul 2015 15:55:22 GMT

Thanks for the help!

Re: pick and match with variable

sunny_talwar — Tue, 28 Jul 2015 15:57:25 GMT

Not a problem

I am glad I was able to help.

Best,

Sunny