Solved: Re: NPrinting Hyperlink - HTML - Qlik Community

Report Inappropriate Content · ‎2016-01-26

I have the below link that almost work by getting me to the application link from the HTML embedded email message. However,

the %%Change Number%% is not taking me to that specific record in the application link. How do I write html to properly pass the value of the field "Change Number" into the link so that the link takes the user to that record.

The last section"%%Change Title <Link>%%" gives me the title visible in the report instead of the full link and it works great.

<td> <A href="http://wsm9web01p.fenetwork.com:8080/HPSM9.33_PROD/index.do?ctx=docEngine&file=cm3r&query=number%3D%...'&%%Change Number]%%& '%22'%%">%%Change Title <Link>%% </A></td>

Daniel_Jenkins · ‎2016-01-26

Hi Deborah,

Try this syntax. I have highlighted the field used in red:

<tr>
<td style="width:100px">Salesman</td>
<td style="width:100px">Quantity</td>
<td style="width:100px">Sales</td>
<td style="width:100px">Link</td>
</tr>
<tr>
<td style="width:100px">%%Salesman%%</td>
<td style="width:100px">%%Quantity%%</td>
<td style="width:100px">%%Sales%%</td>
<td><a href="http://wsm9web01p.fenetwork.com:8080/HPSM9.33_PROD/index.do?ctx=docEngine&file=cm3r&query=number%3D%...%%Salesman%%"& '%22'%%">%%Salesman%%<Link> </a></td>
</tr>
</table>

</body>
</html>

HTH - Daniel.

View solution in original post

Daniel_Jenkins · ‎2016-01-26

Hi Deborah,

Try this syntax. I have highlighted the field used in red:

<tr>
<td style="width:100px">Salesman</td>
<td style="width:100px">Quantity</td>
<td style="width:100px">Sales</td>
<td style="width:100px">Link</td>
</tr>
<tr>
<td style="width:100px">%%Salesman%%</td>
<td style="width:100px">%%Quantity%%</td>
<td style="width:100px">%%Sales%%</td>
<td><a href="http://wsm9web01p.fenetwork.com:8080/HPSM9.33_PROD/index.do?ctx=docEngine&file=cm3r&query=number%3D%...%%Salesman%%"& '%22'%%">%%Salesman%%<Link> </a></td>
</tr>
</table>

</body>
</html>

HTH - Daniel.

Report Inappropriate Content · ‎2016-01-26

Thank you. Will give it a try

Report Inappropriate Content · ‎2016-01-26

Worked like a charm. Thank you very much. Now how do I sort it in descending order by a particular field

Daniel_Jenkins · ‎2016-01-26

Hi Deborah,

Glad that worked for you.

QlikView NPrinting does not sort data - you will need to sort the source chart in QlikView as required.

HTH - Daniel.

Report Inappropriate Content · ‎2016-01-26

I have the object sorted but it is not using the sort order. I thought because I was bringing in columns and not the entire chart object, it would not work. I used levels to group them but it is ASC and I want DESC which I have in the chart object.

One more small question 🙂 How do you change the color of the header row only or BOLD it?

Daniel_Jenkins · ‎2016-01-26

Hi Deborah,

It works for me as the screenshot in my previous reply shows. If you can share your project (NSQ, QVW & Template) someone here can take a look.

You can use Inline Styling to format the header.

Example:

<tr>

<td style="color:darkblue;font-weight: bold;text-align:center;width:100px">Salesman</td>

<td style="color:darkblue;font-weight: bold;text-align:center;width:100px">Quantity</td>

<td style="color:darkblue;font-weight: bold;text-align:center;width:100px">Sales</td>

</tr>

gives:

- Daniel.

Report Inappropriate Content · ‎2016-01-26

I had to update the object a couple of times. The sort is working now.

Does inline styling work with the headers that are automatically created from the code td code?

Daniel_Jenkins · ‎2016-01-26

Sorry I don't understand your question. I suggest that you go through this document:

How to Apply HTML Formatting to NPrinting HTML Reports

HTH - Daniel.

manojkulkarni · ‎2017-09-12

Hi Deborah,

How can we add link in power point or word reports ?