topic Re: Displaying URL in Straight Table in QlikView

Displaying URL in Straight Table

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

Hi,

I have two questions. In the attached file, I loaded URLs using IN LINE. On the resulting straight table, when clicking the URL I am getting a Failed to Launch error message. Any idea how to fix?

In the same file, I also loaded URL's using a file instead of IN LINE. I am wondering how can I modify the script so that the values on the field, URL_,2 will be in the proper format ..... 'Link<URL>URL'? I can do this manually IN LINE but what if I am not loading IN LINE such as the case here?

Re: Displaying URL in Straight Table

vishsaggi — Wed, 18 Apr 2018 14:52:57 GMT

Try adding another field like Name

In your excel sheet add below Name

ID	URL_2	Name
ABC	https://www.google.com	Google
DEF	https://www.yahoo.com	Yahoo

LOAD ID,
URL_2,
Name
FROM
[..\..\Book1_url.xlsx]
(ooxml, embedded labels, table is Sheet1);

Then in your straight table expr

Dim: ID

Expr: = Name & '<URL>' & URL_2

Re: Displaying URL in Straight Table

Anonymous — Wed, 18 Apr 2018 15:50:03 GMT

Hi, hmm this didn't work.

Re: Displaying URL in Straight Table

vishsaggi — Wed, 18 Apr 2018 15:57:47 GMT

Can you share that app where you added Name URL link that is not working.? It worked for me.

Re: Displaying URL in Straight Table

olivierrobin — Wed, 18 Apr 2018 16:01:47 GMT

hello

don't forget to select link in expressions/display options/ representation

Re: Displaying URL in Straight Table

Anonymous — Wed, 18 Apr 2018 16:08:29 GMT

Let me know if I did something wrong?

Re: Displaying URL in Straight Table

vishsaggi — Wed, 18 Apr 2018 16:17:35 GMT

You are using the wrong field in the expression tab use below

=NAME&'<URL>'&URL_2

Re: Displaying URL in Straight Table

jubarrosor — Wed, 18 Apr 2018 16:55:14 GMT

Hi Mark:

I think that this thread could help you:

URL in Straight Table not Working

Best Regards,

Juan P. Barroso

Re: Displaying URL in Straight Table

Anonymous — Wed, 18 Apr 2018 17:52:48 GMT

Wow don't know how I missed that. Thanks!

Re: Displaying URL in Straight Table

vishsaggi — Wed, 18 Apr 2018 19:16:34 GMT

Did it not solve your issue? If yes can you close the thread marking correct/helpful responses accordingly.

Re: Displaying URL in Straight Table

khalander — Fri, 22 Mar 2019 12:55:15 GMT

Hi,

Is it working for you?

I am facing issue, it is not working in straight table and same thing is working in table box