topic Re: URL from Access in QlikView

URL from Access

NickHoff — Wed, 18 Dec 2013 13:55:42 GMT

I'm putting a URL in a straight table, and enabling the references a link, but the formatting of my url is preventing it from working. Currently it's formatted with # before and # where it ends like: #http://www.blah.com#. Is there a work around to get the link to work?

Re: URL from Access

Josh_Good — Wed, 18 Dec 2013 20:58:28 GMT

The syntax is LinkName<URL>Link as in Google<ULR>www.google.com you will need to strip out the # on each end. Also don't forget to set the expression to "Link".

Re: URL from Access

NickHoff — Wed, 18 Dec 2013 21:09:10 GMT

Would you use something like:

textbetween('<Table.TuppleName>','#', ') on the load to strip the #'s, the field in the database has thousands of different links, so when I preform the load for the straight table how do I get it to show all the links without going into each one to change the syntax?

Re: URL from Access

Wed, 18 Dec 2013 22:10:32 GMT

Do you wan the URL to have # before and After, Is that a requirement or that how your data is ?

Re: URL from Access

NickHoff — Wed, 18 Dec 2013 22:13:05 GMT

The URL is stored that way in the data. Preferably I would like to remove the # and have a clickable URL in a straight table in a field called URL.

Re: URL from Access

Wed, 18 Dec 2013 22:15:38 GMT

replace(MaxString(URL),'#','') & '<URL>' & replace(MaxString(URL),'#','')

you have to use this in the expression , Not load statement

Re: URL from Access

NickHoff — Wed, 18 Dec 2013 22:19:36 GMT

replace(MaxString(URL),'#','') & '<URL>' & replace(MaxString(URL),'#','') as URL

gives me an invalid expression error

Re: Re: URL from Access

Josh_Good — Wed, 18 Dec 2013 23:01:54 GMT

I don't think you need the MaxString statement. Try:

Replace(URL,'#','') & '<URL>' & Replace(URL,'#','')

Re: URL from Access

Colin-Albert — Wed, 18 Dec 2013 23:40:11 GMT

Purgechar(URL, '#') will remove all occurrences of # in the URL data.

This is best done in the load script.