URL with multiple parameters in table? - Qlik Community

anderseriksson · ‎2010-11-23

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

Report Inappropriate Content · ‎2010-11-23

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

anderseriksson · ‎2010-11-25

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

Report Inappropriate Content · ‎2010-11-25

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

anderseriksson · ‎2010-11-26

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

Report Inappropriate Content · ‎2010-11-26

Hi,

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

-Alex

anderseriksson · ‎2010-11-26

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

Report Inappropriate Content · ‎2010-11-30

hi,

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

-Alex

anderseriksson · ‎2010-11-30

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

Report Inappropriate Content · ‎2010-11-30

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