HL in Excel

[maxime66]

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.

[marcus_sommer]

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

- Marcus

[maxime66]

thanks marcus !

i will ,

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

best regards.

[marcus_sommer]

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

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

[maxime66 · Accepted solution]

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 !

[maxime66]

Hi again,

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

Max.

[Ruggero_Piccoli]

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.