topic Re: Hyperlink from Qlik Sense not working in Qlik NPrinting

Hyperlink from Qlik Sense not working

Danijel — Thu, 07 Apr 2022 10:53:26 GMT

Hello all,

We have in a Qlik Sense application within a table a field with a url. This field is also displayed as url and works within the Qlik Sense application (Feb 2022 Patch1).

Now we distribute this tab as html report within an email (NP May 2021 SR4). There the "link" is no longer displayed correctly. Only the name "Link" is displayed as hyperlink.

I have already tested it with HTML Encode, as well as a formula within the report.

My HTML code is:
<td valign=top height=25 width=150> <a href="%%url_1%%">Link</a> </td>

Does anyone have any other ideas?

Greetings

Re: Hyperlink from Qlik Sense not working

Frank_S — Thu, 07 Apr 2022 13:11:47 GMT

@Danijel

I would suggest turning on your Developer tools and checking for errors when you click that link.

Further, and full disclosure, it's not abundantly clear at to what your use case here is. Is it a link to an NPrinting Report? Does the link work when you click it in Qlik Sense hub?

We don't know what the hyperlink is suppose to do or connect to (a bit of a black box here).

If you could clarify the detailed steps to reproduce the issue, then perhaps we could provide additional insight.

Kind regards...

Re: Hyperlink from Qlik Sense not working

Danijel — Thu, 07 Apr 2022 15:24:10 GMT

Hello @Frank_S ,

within the Qlik Sense application I have a link which also works within the application.

The link opens a specific web page.

As soon as I now distribute the table in NP the defined name is stored as hyperlink, the actual link to the web page is no longer present.

I was able to reproduce this with a small example.

In the attachment still two pictures for this.

Greetings

Re: Hyperlink from Qlik Sense not working

Frank_S — Thu, 07 Apr 2022 16:08:12 GMT

Ok it seems clearer now but just to confirm.

You want to see the actual link ie: www.google.com

rather than 'Link'

Is that correct?

Does clicking 'Link' still take you to the expected web address? or does it fail to redirect you to the intended internet address entirely?

Lastly,

Make sure to check that the table object is up to date:

Refresh the NPrinting Connection
Right click on the table object in the NPrinting Designer
click 'Update'

Perhaps this solves the issue?

Thanks!

Re: Hyperlink from Qlik Sense not working

Danijel — Fri, 08 Apr 2022 05:50:20 GMT

Hello @Frank_S ,

I would like to see the term "link", but behind it should be the hyperlink to www.google.com.

So, when I click on the link, the page from google should open.

Currently, only the browser with the address "Link" is opened here, as seen in the second image.

I have already updated the metadata several times, as well as the table within the designer. I have also already re-added these several times.

Greetings

Re: Hyperlink from Qlik Sense not working

Ruggero_Piccoli — Fri, 08 Apr 2022 08:31:47 GMT

Hi,

Did you already checked the following articles?

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Hyperlink-in-NPrinting-HTML-Report/td-p/1610694

https://community.qlik.com/t5/Qlik-NPrinting-Documents/Dynamic-Links-in-Qlik-NPrinting-Reports-to-Sense-Apps/ta-p/1562314

Best Regards,

Ruggero

Re: Hyperlink from Qlik Sense not working

Danijel — Fri, 08 Apr 2022 10:52:59 GMT

Hi @Ruggero_Piccoli

yes the posts I had found before, unfortunately they do not help me here.

I have a field in which the complete URL is stored, nothing needs to be transformed or added here.

I have already tested with the formulas. Unfortunately without success.

If necessary, I can also attach a QA sample app with NP report.

Greetings

Re: Hyperlink from Qlik Sense not working

Frank_S — Fri, 08 Apr 2022 13:24:51 GMT

@Danijel

Yes, please share a sample and I will be happy to test.

Kind regards...

Re: Hyperlink from Qlik Sense not working

Danijel — Fri, 08 Apr 2022 13:47:53 GMT

thanks @Frank_S

attached the Qlik Sense application and the NPrinting report.

Thank you.

Re: Hyperlink from Qlik Sense not working

Frank_S — Fri, 08 Apr 2022 16:28:13 GMT

Hi @Ruggero_Piccoli

I have test this many different ways and it is not working where inserting the URL field produces an active link.

I also tried

Switching to 'text' rather than 'link' representation in the source QVF and still get the same output.
<a href="url">link text</a> in the html editor but I only get 'url' not the website as expected.

Clicking either website link generated the browser output on the bottom right corner of the image below.
Perhaps you have have a look at this one...thx!

Re: Hyperlink from Qlik Sense not working

Ruggero_Piccoli — Mon, 11 Apr 2022 09:55:52 GMT

Hi,

Create a Qlik Sense table as you did:

Hyperlinks: LOAD * Inline [ Site, URL, Hyperlink Google, https://www.google.com/, <a href="https://www.google.com/">Google</a> Qlik, https://www.qlik.com/, <a href="https://www.qlik.com/">Qlik</a> ]

Create the Qlik NPrinting connection and cache as usual then create an HTML template:

I set Show Headers to Hide just for esthetic reasons but you have to remove the Keep Source Format flag to avoid uncontrolled HTML style code in the generated report.

The generic HTML link has the structure (from https://www.w3schools.com/tags/tag_a.asp)

<a href="https://www.w3schools.com">Visit W3Schools.com!</a>

so I generated the second column by building the link using Qlik NPrinting tags

Instead the third column is made by generating the HTML tag in the Qlik Sense reload script. This keeps very simple the template side

<td>%%Hyperlink%%</td>

Run a report preview

and you will have the HTML code generated in both cases.

Best Regards,

Ruggero

Re: Hyperlink from Qlik Sense not working

Frank_S — Mon, 11 Apr 2022 18:52:56 GMT

@Danijel

Also, in the load script editor, I wrapped the urls with double quotes, reloaded the NP connection, previewed the your html report in the template editor and suddenly the links worked with your NP report output.

Sites:
LOAD * INLINE [
Site, url
google, "https://www.google.com"
qlik, "https://qlik.com"
];

Re: Hyperlink from Qlik Sense not working

Frank_S — Mon, 11 Apr 2022 18:37:10 GMT

Thanks @Ruggero_Piccoli for your invaluable input as always!

Re: Hyperlink from Qlik Sense not working

Danijel — Tue, 19 Apr 2022 11:57:33 GMT

Hello @Frank_S and @Ruggero_Piccoli

thanks for your effort, great suggestions!

I have taken a closer look at Frank's suggestion. Since the url comes from the source system in a field, the must add the " separately.

My idea was to use the chr(34), unfortunately within QS I get a wrong representation of the url displayed, which of course doesn't work either.

Do I have a thinking error somewhere here?

something else interesting:

when I select, the content is displayed correctly. However, QS does not seem to interpret the link function of the url correctly.

Re: Hyperlink from Qlik Sense not working

Frank_S — Tue, 19 Apr 2022 19:30:17 GMT

Hi @Danijel

I see...

Well there seems to be alot of discussion around that on the internet

https://www.google.com/search?client=firefox-b-d&q=chr%2834%29

I'll cc @Ruggero_Piccoli in case he has any other ideas on this.

Re: Hyperlink from Qlik Sense not working

Danijel — Tue, 26 Apr 2022 08:47:36 GMT

Hi @Frank_S @Ruggero_Piccoli ,

I have tested something else. I have made some progress with the ApplyCodePage function. With this I apparently don't need the " anymore.

Last problem, as soon as I enter a link label, I get the label as a value in NP, if this is left empty, the link is correctly displayed and can be called.

Can anyone of you confirm this?

Re: Hyperlink from Qlik Sense not working

Frank_S — Tue, 26 Apr 2022 18:35:07 GMT

@Danijel

Not sure what you mean by "as soon as I enter a link label, I get the label as a value in NP"

However what I did notice is that regardless of what I type into the link label field, "link" appears in the email report output regardless of what is typed into the label field.

Also if I leave the field 'blank', Link is still shown in the output.

In both cases the links works whether I use a link label or leave it blank.

Re: Hyperlink from Qlik Sense not working

Danijel — Thu, 28 Apr 2022 10:28:08 GMT

Hello @Frank_S

thank you for testing. I have made a short video about this, which again shows my procedure.

I will send you the video via pm.

Re: Hyperlink from Qlik Sense not working

Frank_S — Mon, 02 May 2022 17:49:31 GMT

Hi @Danijel

I wasn't able to find any other alternate solutions despite a concerted effort to do so over the past few days and including today.

Wrapping your urls with double quotes and using 'text' rather than 'link' to represent the url data in the QS app works perfectly.

You also need to deselect 'keep source formats' on the url field.

Here below is representation of the changes I made directly to the app in the QS hub editor. I am also attaching the source file is used.

Kind regards...

Re: Hyperlink from Qlik Sense not working

Danijel — Tue, 03 May 2022 06:53:36 GMT

Hi @Frank_S

Thank you very much for your effort. I will also test it again and get back to you.

Greetings