Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
markramiro
Creator II
Creator II

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

View solution in original post

markramiro
Creator II
Creator II
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

markramiro
Creator II
Creator II
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

jubarros
Luminary Alumni
Luminary Alumni

Hi Mark:

I think that this thread could help you:

URL in Straight Table not Working

Best Regards,

Juan P. Barroso

markramiro
Creator II
Creator II
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.