Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
markramiro
Contributor 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
Esteemed Contributor III

Re: Displaying URL in Straight Table

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
Esteemed Contributor III

Re: Displaying URL in Straight Table

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
Contributor II

Re: Displaying URL in Straight Table

Hi, hmm this didn't work.

vishsaggi
Esteemed Contributor III

Re: Displaying URL in Straight Table

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

olivierrobin
Valued Contributor III

Re: Displaying URL in Straight Table

hello

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

markramiro
Contributor II

Re: Displaying URL in Straight Table

Let me know if I did something wrong?

vishsaggi
Esteemed Contributor III

Re: Displaying URL in Straight Table

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

=NAME&'<URL>'&URL_2

Luminary
Luminary

Re: Displaying URL in Straight Table

Hi Mark:

I think that this thread could help you:

URL in Straight Table not Working

Best Regards,

Juan P. Barroso

markramiro
Contributor II

Re: Displaying URL in Straight Table

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

vishsaggi
Esteemed Contributor III

Re: Displaying URL in Straight Table

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