Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
JustJoshin
Contributor
Contributor

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

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>

Labels (1)
7 Replies
lironbaram
Partner - Master III
Partner - Master III

hi 

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

JustJoshin
Contributor
Contributor
Author

I was trying to do this in an HTML report.

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

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

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
JustJoshin
Contributor
Contributor
Author

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
Contributor
Contributor
Author

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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

 

 

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.