Qliksense expression help

jpjust — Mon, 17 Jan 2022 14:41:14 GMT

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

Re: Qliksense expression help

rwunderlich — Mon, 17 Jan 2022 15:47:27 GMT

Can you post your current expression?

-Rob