URL with multiple parameters in table?

[anderseriksson]

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

[#2]

Hi

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?

[#3]

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

[#4]

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

[#5]

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

[#6]

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

[#7]

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