All,
I need an solution here.
I have created an excel sheet where business can maintain their email address and other information.
This sheet gets loaded into the APP, which creates variables for To, CC and BCC.
I want to create a sheet in qliksense where these variables are visible so the business users can see who is in To,CC,BCC.
Now I’m running into email address with a QUOTE (Mark.A’gakin@....) in it.
At displaying the variable, Qlik thinks that after Mark.A this variable stops and everything behind it is seen as garbage.
I’ve tried REPLACE() I’ve tried ALT(), …without help
The expression throws the following error
Error in Expression - Garbage after expression: gakin@domain.com
Can some one help me with an work around for this so the complete email address is displayed as Mark.A’gakin@domain.com
Thanks
