topic Re: Qliksense: URL Encoding ($=%24) in Integration, Extension & APIs

Qliksense: URL Encoding ($=%24)

luke1986 — Tue, 29 May 2018 11:28:47 GMT

Hello Folks,

Iam facing a problem with the automatic encoding of links (URL) in a Qliksense Table Chart.

We are using Navision as ERP System.

If you build a link that should open a Tab from Navision, it usually contains a '$' (Dollar Sign) in the link.

Something like this: ...your$company\runpage?page=...

If you now click on the link, it will open the $ as %24, which is no problem for Website links, but for Navision it is.

So i tried to put chr(36) instead of $, to maybe solve the Problem, but that didnt help either.

This problems only accure with Chrome, Firefox, Opera browser, in IE it works, but since QS is optimized for Chrome, i dont want to switch.

Does anybody has a solution?

Greetz Lukas

Nachricht geändert durch Lukas Amann

Re: Qliksense: URL Encoding ($=%24)

petter — Tue, 29 May 2018 13:06:29 GMT

Chr(36) is $ .... Chr(39) is not.

Was it a typo?

Re: Qliksense: URL Encoding ($=%24)

luke1986 — Tue, 29 May 2018 13:09:03 GMT

Yea sorry, just a typo 🙂 I will fix that.

Re: Qliksense: URL Encoding ($=%24)

Levi_Turner — Thu, 31 May 2018 14:37:04 GMT

Please contact Qlik Support. From my side, I've seen a scenario where &pi was interpreted as π by the client side JavaScript code in Qlik Sense but this should be fixed in Qlik Sense February 2018. So if the behavior is presenting the past that build for your scenario then there is a potential defect there.

Re: Qliksense: URL Encoding ($=%24)

luke1986 — Thu, 31 May 2018 15:55:50 GMT

Iam running the newest Version of Qliksense, so that shouldnt be a problem.

Its not wrong per se, it is just the URL encoder which makes it to a %24.

I solved the problem by using a Branch Add on called "simple table". Which at least interpret the $ as Dollar sign.

But you are right, i think a supp ticket might help, i will try that to.

Greetz Lukas

Re: Qliksense: URL Encoding ($=%24)

luke1986 — Wed, 26 Sep 2018 11:44:58 GMT

Update, this is what Qlik R&D wrote me:

--> bug-fix is targeted for Qlik Sense November 2018.

Re: Qliksense: URL Encoding ($=%24)

william_fu — Mon, 08 Oct 2018 18:22:46 GMT

Just faced the same problem here.

Thanks for reaching out to them - frustrating to see them take so long to respond.

Re: Qliksense: URL Encoding ($=%24)

kwdaniels — Thu, 01 Nov 2018 14:48:24 GMT

Same problem here. We we had successfully linked to OpenAir (NetSuite/Oracle) invoices from Qlik before the June 2018 release. It has been broken since then, and we look forward to the fix in the November 2018 release!

FYI, there's what appears to be a somewhat related threat at Qlik Sense June 2018 - URL address cut at "equal" (%3D)

Re: Qliksense: URL Encoding ($=%24)

microland — Wed, 06 Mar 2019 11:33:23 GMT

Hi,

I just upgrated from Feb 2018 to Qliksense Nov 2018 version. Now we are facing the same URL problem. Actually i am using some angularjs method in mashup javascript file. Now it is not working due to URL encoding automatically. Is there any solution for this issue.

Re: Qliksense: URL Encoding ($=%24)

Aladdin — Wed, 22 May 2019 08:50:40 GMT

Seems like it still hasn't been implemented as of Feb 2019.

Re: Qliksense: URL Encoding ($=%24)

heltok — Fri, 13 Dec 2019 09:08:41 GMT

I have a similar problem with URLs in Qlik Sense. Part of the URL I am using is "type=&M=414". Qlik Sense translates this as "type&M=414", in other words the equal sign that don't have any content is removed. I have also tried with the chr() function but without luck. Are there any news regarding solutions to this or similar issues?