Hyperlink in Nprinting Excel Report

[Anonymous]

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

[Anonymous · Accepted solution]

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