Https link Question

[brf10043]

All,

I have the following expression which creates a link with the text "Click Here" which when clicked takes the user to a support ticket (TICKET_ID_).

='Click here<URL>https://vocfeedback.gsk.com/IM_view/ticketInfo.asp?Ticket_ID='&Only($(vIMVolumeDetailCreated)TICKET_...)

How can I alter the code to replace the "Click Here" text with the ticket number (TICKET_ID_)?

[sunny_talwar · Accepted solution]

May be this:

=TICKET_ID_ & '<URL>https://vocfeedback.gsk.com/IM_view/ticketInfo.asp?Ticket_ID='&Only($(vIMVolumeDetailCreated)TICKET_...)

[brf10043]

Thanks Sunny!

That does work perfectly.  Here's a follow up question.  Is there a way to have the link work after you "Send to Excel"?

[sunny_talwar]

Bobby that is a great question. I don't know since I never had to do this. I will look around, but I think this might need a Macro of some sort to make it work. I don't think inbuilt QlikView capabilities would allow for this.

[brf10043]

Thanks Sunny.  I also expect that you would need a macro to make that happen.  However, I don't think that we would want to go that route.  Thanks for your Help!