topic https links and send to Excel in QlikView https://community.qlik.com/t5/QlikView/https-links-and-send-to-Excel/m-p/1200477#M880780 <HTML><HEAD></HEAD><BODY><P>In my document I have a table that includes a link to a support ticket See Expression below.</P><P></P><P><SPAN style="font-size: 10pt;"><SPAN>='Click here&lt;URL&gt;</SPAN><A class="jive-link-external-small" href="https://vocfeedback.gsk.com/IM_view/ticketInfo.asp?Ticket_ID='&amp;" rel="nofollow" target="_blank">https://vocfeedback.gsk.com/IM_view/ticketInfo.asp?Ticket_ID='&amp;</A></SPAN><SPAN style="font-size: 10pt;"><SPAN style="color: #0000ff;">Only</SPAN>(<STRONG><EM style=": ; color: #808080;">$(vIMVolumeDetailCreated)</EM></STRONG></SPAN><SPAN style="font-size: 10pt;">TICKET_ID_)</SPAN></P><P></P><P><SPAN>There are two problems with this approach.</SPAN></P><OL><LI><SPAN>the link does not work when you send the data to Excel</SPAN></LI><LI><SPAN>The column in the table simply reads "Click Here".</SPAN></LI></OL><P></P><P></P><P><SPAN>Is there a way to have the link to the ticket number be the TICKET_ID_ and have the link work from Excel when you have "Sent it to Excel"? </SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT brf10043 2020-11-25T16:16:04Z https links and send to Excel https://community.qlik.com/t5/QlikView/https-links-and-send-to-Excel/m-p/1200477#M880780 <HTML><HEAD></HEAD><BODY><P>In my document I have a table that includes a link to a support ticket See Expression below.</P><P></P><P><SPAN style="font-size: 10pt;"><SPAN>='Click here&lt;URL&gt;</SPAN><A class="jive-link-external-small" href="https://vocfeedback.gsk.com/IM_view/ticketInfo.asp?Ticket_ID='&amp;" rel="nofollow" target="_blank">https://vocfeedback.gsk.com/IM_view/ticketInfo.asp?Ticket_ID='&amp;</A></SPAN><SPAN style="font-size: 10pt;"><SPAN style="color: #0000ff;">Only</SPAN>(<STRONG><EM style=": ; color: #808080;">$(vIMVolumeDetailCreated)</EM></STRONG></SPAN><SPAN style="font-size: 10pt;">TICKET_ID_)</SPAN></P><P></P><P><SPAN>There are two problems with this approach.</SPAN></P><OL><LI><SPAN>the link does not work when you send the data to Excel</SPAN></LI><LI><SPAN>The column in the table simply reads "Click Here".</SPAN></LI></OL><P></P><P></P><P><SPAN>Is there a way to have the link to the ticket number be the TICKET_ID_ and have the link work from Excel when you have "Sent it to Excel"? </SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/https-links-and-send-to-Excel/m-p/1200477#M880780 brf10043 2020-11-25T16:16:04Z