topic Re: How to do NOT evaluate a variable value in QlikView

How to do NOT evaluate a variable value

Tue, 22 Apr 2014 23:37:09 GMT

I have a variable named $Expression and I need to display the content of that variable in a text object. However, when I try to do that, instead of show the content of the variable, the value of the variable is evaluated.

For example, let's say the $Expression is set by the user to be Type='B'. I want to show Type='B' in a text object but instead, the text object evaluates the variable and only shows true or false as a result of the expression evaluation.

Any ideas?

Re: How to do NOT evaluate a variable value

maxgro — Tue, 22 Apr 2014 23:55:12 GMT

set var='Type=' & chr(39) & 'B' & chr(39);

textbox

=$(var)

Re: How to do NOT evaluate a variable value

adriansalas — Tue, 22 Apr 2014 23:57:17 GMT

try:

Set $Expresion = 'B'

for declare static variable.

Re: How to do NOT evaluate a variable value

Wed, 23 Apr 2014 01:00:23 GMT

Thank you guys for the quick reply but that is not an option. Set statement is for load script and this expression variable will be changed by the user in an input box. It is not assigned during load script.

I know how to define the variable, my problem is how to show in a text object without evaluating the variable value.

By the way, for many reasons will take a lot to explain, display in an input box is not an option.

Re: Re: How to do NOT evaluate a variable value

jagan — Wed, 23 Apr 2014 02:12:02 GMT

Hi,

Please find attached file for solution, it is not evaluating the expression.

You just give

=variableName

don't give $(variableName)

Regards,

Jagan.

Re: How to do NOT evaluate a variable value

Wed, 23 Apr 2014 15:00:10 GMT

That worked.

Thanks, Jagan.