topic Re: HL in Excel in Qlik NPrinting

HL in Excel

maxime66 — Tue, 03 Apr 2018 13:56:20 GMT

Hello,

I have a table containing a dimension with hypertext links.

When i export datas to Excel using Nprinting links are not clikable anymore.

Do you know how to solve this issue (without using Macro).

Thanks for your time and help.

Re: HL in Excel

marcus_sommer — Tue, 03 Apr 2018 13:58:52 GMT

Take a look here: Re: Add hyperlink to excel via macro

- Marcus

Re: HL in Excel

maxime66 — Tue, 03 Apr 2018 14:02:26 GMT

thanks marcus !

i will ,

what a pity it can't be done wihout macro ..

best regards.

Re: HL in Excel

marcus_sommer — Tue, 03 Apr 2018 14:23:34 GMT

If I understand the link within the link right then it needs no macros by using NPrinting:

Re: NPrinting report to show links correctly

http://community.vizubi.com/knowledgebase/articles/260346-how-to-apply-html-formatting-to-nprinting-html-rep

Like mentioned in my previous answer here a copy & paste approach should work and could be automated by QlikView macros. If this feature is really important for you the use of QlikView and/or Excel macros is not mandatory an obstacle.

By using AJAX it might be an alternatively to print this table which will open the table within a new tab in purely html and I believe (not tested yet) if you copy & paste it to excel that the links will be working.

- Marcus

Re: HL in Excel

maxime66 — Tue, 03 Apr 2018 15:52:35 GMT

I found the solution with this interesting post :

https://community.qlik.com/docs/DOC-13571

In NPRINTING excel report, I add Levels and a new column in my table ( column B) with formula : HYPERLINK.

works great !

Re: HL in Excel

maxime66 — Wed, 04 Apr 2018 08:53:18 GMT

Hi again,

Quick Note : Links won't be clikable on Mobile devices (Tab or smartphone).

Max.

Re: HL in Excel

Ruggero_Piccoli — Wed, 04 Apr 2018 08:59:05 GMT

Macros are not yet supported in Qlik NPrinting 17 and 18.

Macros VBA code is copied and never executed from the template to the generated reports in Qlik NPrinting 16.