Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Luminary Alumni
Luminary Alumni

Use chr(34) like the following:

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

Regards,

View solution in original post

2 Replies
pover
Luminary Alumni
Luminary Alumni

Use chr(34) like the following:

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

Regards,

Not applicable
Author

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