topic Set Variable to a Formula via Action in QlikView

Set Variable to a Formula via Action

Tue, 09 Nov 2010 17:50:53 GMT

I am trying to set a variable to a formula (i.e., beginning with an equal sign) via an action trigger.

I was able to successfully set a variable to call the =OSUser function by setting the action to assign its value as ='=OSUser()'

However, I can't seem to make this "style" of a formula setting work if the formula itself has quotes in it.

Example:

='=''test'''

Any suggestions???

pover — Tue, 09 Nov 2010 18:07:18 GMT

Use chr(34) like the following:

='='&chr(34)&'test'&chr(34)

Regards,

Tue, 09 Nov 2010 19:21:56 GMT

Thank you very much. FYI, I needed to use chr(39) instead of 34 but it worked great!!!