Hyperlink in Nprinting Excel Report

Anonymous — Tue, 21 Feb 2017 11:55:30 GMT

Hi Everyone,

I'm having a table in my qlikview app with user names and profile link.

I'm trying to generate an excel report for the same through Qlik Nprinting. I tried <a> tag, tried HyperLink function of excel, but nothing worked. Hyperlink function doesn't get evaluated at Excel side and if we do replace all = with =, it works.

Can anyone please help me to get an Nprinting Excel report with working URL which can directly be clicked that will redirect to browser.

I tried with Macros too, but when being previewed macro doesn't get copied over to the exported report and there's no option to Preview as xlsm.

Please note that this is with Nprinting 17.

Many thanks in advance.

Best,

Hardik

Re: Hyperlink in Nprinting Excel Report

Anonymous — Tue, 21 Feb 2017 13:33:38 GMT

Hi Everyone,

As a workaround to this, I was able to add a calculated column through both the options (Levels and Table) and hiding the original column.

With Below Link

https://help.qlik.com/en-US/nprinting/17.2/Content/ExcelReports/HowMakeCalculatedColumnExcelReports/Make-Calculated-Colu…

Thanks.

Hardik

topic Hyperlink in Nprinting Excel Report in Qlik NPrinting

Hyperlink in Nprinting Excel Report

Re: Hyperlink in Nprinting Excel Report