topic Make Column Data into Clickable HTML Link? in QlikView

Make Column Data into Clickable HTML Link?

raynac — Wed, 18 Dec 2013 17:46:15 GMT

I am importing a table into a view where one of the columns contains an HTML address.

It imports, of course, as text, but I am being asked to make that data "clickable" so that the owner here can click on whichever link he wants and be brought straight to the document in question.

Is this something that can be done? I have tried the a href tags and such and all that does is print the a href info in the field.

If it matters, we are currently using Qlikview 8.5 but I could probably upgrade if it made a difference.

Thanks in advance,

Rayna

Re: Make Column Data into Clickable HTML Link?

Anonymous — Wed, 18 Dec 2013 17:49:17 GMT

Ryana,

You can use expression with representation "Link". Expression itself is like this:

=<string expression which will be shown in cell as text> & '<URL>' & 'web address'

Regards,

Michael

Edit: Yes, you have to upgrade. It doesn't exist in 8.5.

Re: Make Column Data into Clickable HTML Link?

Wed, 18 Dec 2013 17:54:45 GMT

Try something like this:

='Click ID - '&OpportunityId&'<url>https://eu1.salesforce.com/'&OpportunityId

Re: Make Column Data into Clickable HTML Link?

raynac — Fri, 17 Jan 2014 21:18:36 GMT

Thanks, Michael! This was extremely helpful. Since my company was still on an old version of Qlikview there was no Link option under "Representation".

Re: Make Column Data into Clickable HTML Link?

raynac — Fri, 17 Jan 2014 21:19:12 GMT

Thank you SO much, Kai! You are a lifesaver - this worked great!