Discussion Board for collaboration related to QlikView App Development.
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.
Use chr(34) like the following:
View solution in original post
Thank you very much. FYI, I needed to use chr(39) instead of 34 but it worked great!!!