How to use URL

[#1]

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

[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.

[#3]

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
];

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
];

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))

[#7]

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

[rwunderlich]

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

[#9]

Thanks. That is bad news...

[rwunderlich]

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

-Rob