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: 
Not applicable

How to use URL

Hi Folks,

I have a data where in the field i have website URLs

Web site topic
q-on.bi

google.com

nasad-it.com

yahoo.com

yahoo.us

and etc

I want to use this url in the application and then from QV open the website how to do this.

Thanks

19 Replies
its_anandrjs

Take a straight table and on that

Write a expression

='Open Website' & '<Url>' & [Web site topic]

And you have any dimension with this let me know.

Not applicable
Author

But in my database some address dont have www in the address and some are start with http://. How can i make it properly same as hyper text transfer protocl (http) and also i want to give its website name in the table. Currentely it is only OpenWebsite but i need website name there.

MarcoWedel

Hi,

and don't forget to set the property 'representation' to 'Link':

LOAD * INLINE [

    Website

    q-on.bi

    google.com

    nasad-it.com

    yahoo.com

    yahoo.us

];

QlikCommunity_Thread_120709_Pic1.JPG.jpg

QlikCommunity_Thread_120709_Pic3.JPG.jpg

hope this helps

regards

Marco

MarcoWedel

Hi again,

one solution could be:

LOAD Distinct

  If(Left(Website, 4)='www.', 'http://'&Website, If(Left(Website, 11)='http://www.', Website, 'http://www.'&Website)) as Website

INLINE [

    Website

    q-on.bi

    google.com

    www.google.com

    http://www.google.com

    nasad-it.com

    yahoo.com

    yahoo.us

];

QlikCommunity_Thread_120709_Pic6.JPG.jpg

QlikCommunity_Thread_120709_Pic5.JPG.jpg

hope this helps

regards

Marco

its_anandrjs

You can try this way also

=if(left(SubField([Web site topic],'//',2),3) = 'www',SubField([Web site topic],'//',2),'www.'&SubField([Web site topic],'//',2))

Not applicable
Author

How do you place a link on a dimension? I can't find the display options here...

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

The Link representation is only available for expressions, not dimensions.

Not applicable
Author

Thanks. That is bad news...

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Can you explain why that's bad news to you? Perhaps I can suggest a solution.

-Rob