topic Link representation problem when data includes a comma in QlikView

Link representation problem when data includes a comma

Mon, 13 Dec 2010 20:03:55 GMT

We're using a Link Representation expression field to launch a PDF based on CustomerName & InvoiceNo from a specified folder. It seems to be working for all customers except for those who have a comma in their company name, in which case the URL shows "%2C" in place of the comma. Any recommendations for coding around this?

Link representation problem when data includes a comma

Oleg_Troyansky — Mon, 13 Dec 2010 20:26:25 GMT

You'll need to use several "replace" functions to eliminate commas, spaces and other special characters, that don't work in the URL syntax.

Link representation problem when data includes a comma

Thu, 12 Apr 2012 17:10:45 GMT

Where would you use those? I also have an URL that I would like to open, but it has three commas in the syntax.

I can correctly show the link in the chart that will open it, and I can display the link as a expression by representing in as a hyperlink, not as a text field, but how do I intercept the URL function?

QV can open the correct URL when I call the URL from a button, but not from an expression.