topic Re: URL Link in Table in QlikView

URL Link in Table

emilyapril — Sat, 16 Nov 2024 21:46:05 GMT

Hi,

I have a URL Link in my table which needs to activated/enabled.

How can I put this in to the script/table expression to enable the link to work?
The field name is [URL Link] and all entries have the required https:\\

I have tried ='URL <url> [URL Link]' found on another question but this "fails to launch"

As always, thanks in advance!

Re: URL Link in Table

lironbaram — Thu, 06 Dec 2018 12:41:55 GMT

have you tried

='URL <url>' & [URL Link]

Re: URL Link in Table

hopkinsc — Thu, 06 Dec 2018 12:43:10 GMT

Did you change the representation in the expression to 'Link'?

Re: URL Link in Table

emilyapril — Thu, 06 Dec 2018 14:09:06 GMT

Thank you!

Yes, the placement of the '' fixed the issue for me 🙂

I've since used a substring in my script as some of the entries had up to 4 URLS in.
I now have 4separate fields to work with, with 4 of the above expressions for each URL (I may join them, yet to decide).

Would you know how to make each expression conditional, because as it stands, if there is no link in the entry, I'm still getting a text representation from the expression which could be confusing to some. Pic attached