topic Re: Https link Question in QlikView

Https link Question

brf10043 — Wed, 25 Nov 2020 16:16:04 GMT

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_ID_)

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

Re: Https link Question

sunny_talwar — Mon, 10 Oct 2016 19:56:44 GMT

May be this:

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

Re: Https link Question

brf10043 — Mon, 10 Oct 2016 20:01:10 GMT

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"?

Re: Https link Question

sunny_talwar — Mon, 10 Oct 2016 20:03:47 GMT

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.

Re: Https link Question

brf10043 — Mon, 10 Oct 2016 20:06:27 GMT

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!