Using a link URL in an nPrinting Report

[Data_Derek]

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.

[TheLazyDevelopr]

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

[Frank_S]

Perhaps this will get you on the right track @Data_Derek 

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

Kind regards...

[Data_Derek]

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.

[Frank_S]

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...

[Lech_Miszkiewicz]

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