topic Dollar sign expansion with variable issue with & operator in expression in QlikView

Dollar sign expansion with variable issue with & operator in expression

adamgaox — Sat, 16 Nov 2024 20:31:46 GMT

Dear All,

I have an issue with dollar sign expansion with my variable;

I have set my variable2 as =MaxString(MTH) & 'Q'

When I use the variable2 in expression

=$(Variable2) in textbox

it will return Garbage after expression 'Q'

but if I write ='$(Variable2)' it will work and show the correct value.

Could anybody explain me the reason?

I have attached my qvw file.

Thanks in advance.

anushree1 — Wed, 03 Jul 2019 11:25:24 GMT

Its because qlikview needs to undestand that the value passed is a string so the quotes help in providing that information, hope that helps

jaibau1993 — Wed, 03 Jul 2019 11:30:48 GMT

Hi!

When you usea a variable with dollar expanssion there are several steps that you have to take into account:

The variable is evaluated (if the variable definition starts with '='). Thus, the expresion =MaxString(MTH) & 'Q' is evaluated. Let's suppose that the evaluation gives JaimeQ (where Jaime is MaxString(MTH))
Expansion: the $(whatever) is substituted by its content. In this case, $(Variable2) is substituted by JaimeQ .
Evaluation: the result of the expanssion is evaluated so QlikView is trying to interpret the expression "=JaimeQ" and it is, obviously, wrong.

Summarizing, when you write in a text box

=$(Variable2)

It is equivalent to

=JaimeQ

WRONG! On the other hand, when you write

='$(Variable2)'

it is equivalent to

='JaimeQ'

CORRECT!

I hope I've explained myself!

Regards,

Jaime.

adamgaox — Thu, 04 Jul 2019 03:59:46 GMT

Thanks a ton.