topic Re: URL Link in Table in QlikView

URL Link in Table

Anonymous — Wed, 09 Sep 2015 14:13:48 GMT

Hi All,

I would like to create a column in a straight table, that when clicking on it, the user will open a URL link,

the URL is 'staticURL' & 'ID'

1. How do I create it as linkable URL ? that by clicing on it a tab will open up with the URL ?

2. How can i mask the actual URL (which is very long and ugly) to 'URL' ?

3. How can I make it Blue and undrlined ?

Thanks!

lironbaram — Wed, 09 Sep 2015 14:29:22 GMT

1. you create a new expression in the table that will have this syntax

='URL <url> staticURL ' & ID

2.in the expression display option you choose representation as Link

this will automatically will display the field with underline

3. if you want the text to be blue , in the expression properties insert to the text color lightblue()

Anonymous — Wed, 09 Sep 2015 15:17:33 GMT

1. great

2. it redirects the user to localhost + url that I enter
how can I solve this ?

3. very good

thanks!!! 🙂

Anonymous — Thu, 10 Sep 2015 14:06:02 GMT

2. when http:// is missing before the URL, the local host address will be added automatically,

so by adding http:// it was solved

result: