Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Displaying URL in Straight Table

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?

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

Try adding another field like Name

In your excel sheet add below Name

 

IDURL_2Name
ABChttps://www.google.comGoogle
DEFhttps://www.yahoo.comYahoo

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

View solution in original post

10 Replies
vishsaggi
Champion III
Champion III

Try adding another field like Name

In your excel sheet add below Name

 

IDURL_2Name
ABChttps://www.google.comGoogle
DEFhttps://www.yahoo.comYahoo

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

Anonymous
Not applicable
Author

Hi, hmm this didn't work.

vishsaggi
Champion III
Champion III

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

olivierrobin
Specialist III
Specialist III

hello

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

Anonymous
Not applicable
Author

Let me know if I did something wrong?

vishsaggi
Champion III
Champion III

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

=NAME&'<URL>'&URL_2

jubarrosor
Partner Ambassador
Partner Ambassador

Hi Mark:

I think that this thread could help you:

URL in Straight Table not Working

Best Regards,

Juan P. Barroso

Anonymous
Not applicable
Author

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

vishsaggi
Champion III
Champion III

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