topic URL with multiple parameters in table? in QlikView

URL with multiple parameters in table?

Anders_Eriksson — Tue, 23 Nov 2010 12:21:14 GMT

I have a table with references to scanned images available on a webserver.
One of the columns in the table is a link column to start the browser and show the scanned image.
My problem is that the URL uses multiple parameters separated by ampersand (&), these are encoded by QlikView into '&26' before the URL is passed to Internet Explorer and then the URL does not work as the web server can't read the parameters correctly.
Changing the column to a text column the URL is displayed correctly in the table but obviously it is not clickable.
Using the same formula for the URL in a button instead does work as the browser then gets the URL without the ampersand encoded into '&26'.
With only one parameter in the URL the problem does not exist and all examples I can see uses only one parameter!

Is there some way of telling QlikView that it should not encode the URL?

Example of the problem;

Should be: http://www.domain.com?P1=1&P2=2
Encoded by QlikView into: http://www.domain.com?P1=1&26P2=2

/Anders

URL with multiple parameters in table?

Tue, 23 Nov 2010 12:38:57 GMT

Can you change the webserver (or put Apache with mod_rewrite in front of it) to be REST style http://www.domain.com/P1/1/P2/2 ?

Or replace on the fly "&26" into "&" ?

-Alex

SV:Re: URL with multiple parameters in table?

Anders_Eriksson — Thu, 25 Nov 2010 12:22:44 GMT

Changing anything on the webserver is not an option as it's not my webserver.
I need QlikView to do it right, had been better if QlikView left it to me to take care of any needed URL encoding in the link column.

/Anders

SV:Re: URL with multiple parameters in table?

Thu, 25 Nov 2010 15:54:18 GMT

hi,

Probably you can't fix QlikView URL encoding, and not the web server.

That's why you could think about using an intermediary web server, ex Apache + mod rewrite. It does exactly that: rewriting URL based on regular expressions.

-Alex

SV:Re: SV:Re: URL with multiple parameters in table?

Anders_Eriksson — Fri, 26 Nov 2010 10:05:14 GMT

Setting up a separate webserver only for that is over the top for the problem and not something I can take to a customer.
For the time being they will have to select a single row and the use a button in QlikView to open the URL since the button works without encoding the URL!

/anders

SV:Re: SV:Re: URL with multiple parameters in table?

Fri, 26 Nov 2010 11:04:28 GMT

Hi,

Just wondering about how complex is a web page that takes 2 parameters and displays an image ? 20 lines of PHP 🙂 ?

-Alex

SV:Re: SV:Re: SV:Re: URL with multiple parameters in table?

Anders_Eriksson — Fri, 26 Nov 2010 18:34:38 GMT

The page is not very complicated but you then assume there is a suitable webserver available for it.
Add the need to setup a webserver and maintain and service that for a problem that should not exist and it is a different matter.
There is a workaround in QlikView but it's not very elegant, force the user to select the row in the table and then have a button opening the URL.
Not as elegant as could be but the problem is not big enough to warrent setting up a webserver to be able to rewrite the request on a middle server.

/anders

SV:Re: SV:Re: SV:Re: URL with multiple parameters in table?

Tue, 30 Nov 2010 10:41:38 GMT

hi,

Actually, it works in QV10 . See here http://community.qlik.com/forums/t/34969.aspx

-Alex

SV:Re: SV:Re: SV:Re: SV:Re: URL with multiple parameters in table?

Anders_Eriksson — Tue, 30 Nov 2010 13:12:41 GMT

I fail to see any difference in that forum thread?
It's still whit only one URL query parameter and then there is no problem.
When more than one query parameter is added is when there is problems.
Thanks for your efforts to help me but the workaround will have to do for the time being.

/anders

SV:Re: SV:Re: SV:Re: SV:Re: URL with multiple parameters in table?

Tue, 30 Nov 2010 13:36:02 GMT

I can't upload QVW files. Replace in that file the links, and URLs with several params work fine for me. Using QV10 desktop .



LOAD * INLINE [
 F1, F2
 a, http://www.google.com/search?as_q=qlikview
 b, http://search.yahoo.com/search?p=qlikview&toggle=1&cop=mss&ei=UTF-8&fr=yfp-t-892
 c, http://www.bing.com/search?q=qlikview&go=&form=QBLH&qs=n&sk=&sc=8-6
];

-alex

SV:Re: SV:Re: SV:Re: SV:Re: URL with multiple parameters in table?

Wed, 16 Mar 2011 09:35:15 GMT

I do have the same problem here

I have a website which support parameters separated by the '+' sign

...?OP=SEARCH+FACTORY=chg+SKIPLIST=1+QBE.EQ.id=403719

When I configure it the url into Qlikview, I obviously use the '+' sign as well

But when I click on the link, QV does re-encoding and the output link now becomes:

?OP=SEARCH%2BFACTORY=chg%2BSKIPLIST=1%2BQBE.EQ.id=403719

Which is not accepted by the website.

Alexandru, the problem is not to launch a website, but the encoding which is forced by QV and not supported by the target website (and I don't have the hand on this website)

Any help?

SV:Re: SV:Re: SV:Re: SV:Re: URL with multiple parameters in table?

Wed, 16 Mar 2011 09:44:36 GMT

I would agree that the target website should handle both '+' and '%2B'; problem is that we do not maintain this website.

Amazing that the button with OpenURL does not force any encoding...

SV:Re: SV:Re: SV:Re: SV:Re: URL with multiple parameters in table?

Wed, 16 Mar 2011 10:41:40 GMT

Hi,

You don't control the website. But can you install Apache on another machine, and route the web traffic thru this Apache that fixes the encoding ?

-Alex

SV:Re: SV:Re: SV:Re: SV:Re: URL with multiple parameters in table?

Wed, 23 Mar 2011 02:16:54 GMT

Hi Alexandru,

In large companies, I am not sure you would like to justify the installation of an Apache server on a Production environment, just to fix the URL encoding which is done by Qlikview.

It is a solution indeed, but we are trying to keep architecture of the project simple.

Thanks

SV:Re: SV:Re: SV:Re: SV:Re: URL with multiple parameters in table?

Wed, 23 Mar 2011 05:54:07 GMT

Hi,

So you've got a list of parameters P1, P2 about some images stored as http://www.domain.com?P1=1&P2=2 ?

With a batch process you could download and rename the files


wget http://www.domain.com?P1=1&P2=2 -o img_P1_P2.png

You could store the images in a folder, add that folder as "root folder" in QEMC -> serve the images with QV web server

-alex

SV:Re: SV:Re: SV:Re: SV:Re: URL with multiple parameters in table?

Wed, 23 Mar 2011 05:56:14 GMT


I have a website which support parameters separated by the '+' sign
...?OP=SEARCH+FACTORY=chg+SKIPLIST=1+QBE.EQ.id=403719

+ is the URL escape for space, and the separator should be &. You have theese parameters:

OP=SEARCH<<SPACE>>

FACTORY=chg<<SPACE>>

SKIPLIST=1<<SPACE>>

Use the trim() function to get rid of tralling white space characters, and use the &

-Alex