Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Set Variable to a Formula via Action

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???

1 Solution

Accepted Solutions
pover
Honored Contributor

Set Variable to a Formula via Action

Use chr(34) like the following:

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

Regards,

2 Replies
pover
Honored Contributor

Set Variable to a Formula via Action

Use chr(34) like the following:

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

Regards,

Not applicable

Set Variable to a Formula via Action

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

Community Browser