topic Using Match function with variables in QlikView

Using Match function with variables

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

Hi,

how to use match with variables?

in attach a small example with a variable, where if i copy text value it work's but if i intend to use the variable don´t.

cam you help me ?

thanks

Ricardo

Peter_Cammaert — Mon, 15 May 2017 15:33:02 GMT

That is because your variable contains unquote shortened month names. The $-sign expansion will result in an invalid parameter list.

You could change this into somthing like

=Match('Jan', $(=chr(39) & replace(MonthNames, ';', chr(39) & ',' & chr(39)) & chr(39)))

but that looks overly complex to me...

[Edit] Corrected expression to use MonthNames variable. Works better

Anonymous — Mon, 15 May 2017 15:42:35 GMT

Peter,

did not work.

Peter_Cammaert — Mon, 15 May 2017 15:44:03 GMT

Yes, because your vMonthNames variable already did contain a complex expression. Try again with the amended example...

Peter_Cammaert — Mon, 15 May 2017 15:46:19 GMT

Ah, this also works well:

=Match('Jan', $(=$(vMonthNames)))

Anonymous — Mon, 15 May 2017 15:50:49 GMT

Peter,

works fine.

And now I understand your answer.

thanks