topic Re: NPrinting Hyperlink - HTML in Qlik NPrinting

NPrinting Hyperlink - HTML

Tue, 26 Jan 2016 21:15:21 GMT

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%22'&%%Change Number]%%& '%22'%%">%%Change Title <Link>%% </A></td>

Re: NPrinting Hyperlink - HTML

Daniel_Jenkins — Tue, 26 Jan 2016 23:02:45 GMT

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%22'&%%Salesman%%"& '%22'%%">%%Salesman%%<Link> </a></td>
</tr>
</table>

</body>
</html>

HTH - Daniel.

Re: NPrinting Hyperlink - HTML

Wed, 27 Jan 2016 00:01:00 GMT

Thank you. Will give it a try

Re: NPrinting Hyperlink - HTML

Wed, 27 Jan 2016 00:24:20 GMT

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

Re: NPrinting Hyperlink - HTML

Daniel_Jenkins — Wed, 27 Jan 2016 00:38:01 GMT

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.

Re: NPrinting Hyperlink - HTML

Wed, 27 Jan 2016 00:54:01 GMT

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?

Re: NPrinting Hyperlink - HTML

Daniel_Jenkins — Wed, 27 Jan 2016 01:15:50 GMT

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.

Re: NPrinting Hyperlink - HTML

Wed, 27 Jan 2016 01:33:57 GMT

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?

Re: NPrinting Hyperlink - HTML

Daniel_Jenkins — Wed, 27 Jan 2016 01:53:03 GMT

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.

Re: NPrinting Hyperlink - HTML

manojkulkarni — Tue, 12 Sep 2017 10:13:06 GMT

Hi Deborah,

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