Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Highlighted
hgpatel172
Contributor

Hyperlink in Nprinting Excel Report

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

1 Solution

Accepted Solutions
hgpatel172
Contributor

Re: Hyperlink in Nprinting Excel Report

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

Thanks.

Hardik

1 Reply
hgpatel172
Contributor

Re: Hyperlink in Nprinting Excel Report

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

Thanks.

Hardik