topic Re: Using a link URL in an nPrinting Report in Qlik NPrinting

Using a link URL in an nPrinting Report

Data_Derek — Wed, 17 Jul 2024 17:52:56 GMT

In Qlik, I created a link url using a dimension.

I then created an excel nPrinting report, where the intent was to have anyone accessing the report be able to utilize the link.

The link works as intended in the qlik object, but on the excel report, the link is to a c: /downloads path and does not take the user to the intended site.

I am working with nPrinting May 2023 SR1.

Any solutions that can be offered would be much appreciated.

Thank you for your time.

Re: Using a link URL in an nPrinting Report

TheLazyDevelopr — Wed, 17 Jul 2024 18:45:55 GMT

Here is a option:
https://community.qlik.com/t5/Qlik-NPrinting/HL-in-Excel/td-p/45882

Re: Using a link URL in an nPrinting Report

Frank_S — Wed, 17 Jul 2024 22:51:35 GMT

Perhaps this will get you on the right track @Data_Derek

QVF and source data (updated with unique URLs per supplier) attached.

Kind regards...

Re: Using a link URL in an nPrinting Report

Data_Derek — Thu, 18 Jul 2024 09:39:35 GMT

Hey Frank,

Your solution seems to be for an HTML report. I want to have the links work in an excel XLSX report.

I have set up the object as a link reference (same as how you pictured above), but when the excel report is generated, the links no longer follow the https path and instead follow a c drive path.

Re: Using a link URL in an nPrinting Report

Frank_S — Thu, 18 Jul 2024 14:21:32 GMT

Just build an NP excel report instead of an html report with the same report object (there is only one). I don't have excel on the server where I created the report so I just used the HTML format.

Try it with the QVF I shared here and let me know. Kind regards...

Re: Using a link URL in an nPrinting Report

Lech_Miszkiewicz — Fri, 19 Jul 2024 08:58:00 GMT

Please read through this topic where i explain how to use hyperlink function:

https://community.qlik.com/t5/Qlik-NPrinting/NPrinting-19-URL-link-in-PDF-report/td-p/1729528