Creating HTML links for each cell in a column based on the column text

[JustJoshin]

I have a column with the nameid for tickets that I want to make the text for each cell a link to that specific ticket. All of the links would share the same structure except the final part of the URL which would be the ticketid.

I've tried both of these but they do not work.

<a href="https://exampleurl/%%Link%%">%%Link%%<Link> </a>

<a href="https://exampleurl/">%%Link%%</a>

[lironbaram]

hi 

what type of report you try to build (html,excel,pdf)

[JustJoshin]

I was trying to do this in an HTML report.

[Lech_Miszkiewicz]

Hi,

You need to have your links in Table tag and you have to disable "Kepp source format and encode" in order to pass "pure text as is in your table as your html code"

see this topic where I described the same scenario for colours:

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Nprinting-HTML-How-change-background-color-...

[JustJoshin]

Just getting a string of Text "id1id2id3" when I disable the formatting. The table on the qlikview has the formatting as

Id1
Id2

as hyperlinks already but when its coming in the actual hyperlink part is being dropped. Maybe I just need to format this as an excel based on what I am seeing in other posts but was hoping to keep it in html .

[JustJoshin]

Here's where I'm at.

I switched to using the excel report type. To try to generate the links I have a column I've made with this formula:

=HYPERLINK("https://examplelink/"&M1,M1)

The M column has the "key" text column from my table that has the last chunk of the url.

This works for the first data row perfectly but draging the folumla into more cells in the column does not show up in the finished report.

[Lech_Miszkiewicz]

For use with nprinting HTML report  you need to have in Qlik table hyperlink visible as a standard text. Basicly you will be passing as text from table whatever hyperlink value you need to html report. 

If you want to put together some sample qvf and few screenshot of how your report needs to look like in html I can work on solution.

re, excel template, seems like you did not follow metodology of building tables and passing formulas in excel templates. (it is not simple drug formula approach). More on https://help.qlik.com under NPrinitng section

cheers

[Daniel_Jenkins]

Hi @JustJoshin ,

Here are two examples:

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/NPrinting-Hyperlink-HTML/td-p/1077914

https://community.qlik.com/t5/Qlik-NPrinting-Discussions/NPrinting-Hyperlink-HTML/td-p/1077914

HTH - Daniel.