Passing parameter strings that contain special characters

mindyckay — Tue, 07 Mar 2017 22:25:07 GMT

All,

We’re running into issues when testing parameters into QlikView when the strings contain special characters. Could someone please advice on what the correct syntax is to account for this?

Sample URL code only:

http://qlikviewdev.com/QvAJAXZfc/opendoc.htm?document=Test%20Ad%20Hoc.qvw&host=QVS%40testqv1&bookmark=Document%5CBM01&sheet=SH05&selecthttp://qlikviewdev.com/QvAJAXZfc/opendoc.htm?document=Test%20Ad%20Hoc.qvw&host=QVS%40testqv1&bookmark=Document%5CBM01&sheet=SH05&select=LB86,%22CC%22%2C%22TAM%20US%22&select=LB12 =LB86,%22CC%22%2C%22TAM%20US%22&select=LB12,______________

Without special characters, no issues encountered.

&select=LB86,%22CC%22%2C%22TAM%20US%22

Team Name (LB86):

TAM US

With special characters, no values are passed no matter what we’ve tried so far.

&select=LB12, _____________?

Vendor Name (LB12):

Smith, John A

*ESEXLAB*

2L *PRODUCTS

L&S ELECTRONICS, INC.

TOP MEDICAL DEVICES, INC / MD

D.S. CEST/UROL (CEST ME

MCTVOCDU,

Thanks,

Mindy

Re: Passing parameter strings that contain special characters

marcus_sommer — Wed, 08 Mar 2017 09:39:38 GMT

I think you will need to mask these special chars. To make this within the url-expression is probably quite difficult but within the script it's quite easy by loading your field twice - one time it's normal and the another it's adjusted to the masking. Here is a small example in the opposite direction but I think you could just adapt the logic:

MapHTMLtoASCII:

mapping load * inline [

HTML, ASCII

Ü, Ü

Ä, Ä

Ö, Ö

", "

&, &

];

load mapsubstring('MapHTMLtoASCII', Name) as Name;

load * inline [

Name

XXXX & SÖHNE GmbH&Co.KG

];

- Marcus

topic Re: Passing parameter strings that contain special characters in QlikView

Passing parameter strings that contain special characters

Re: Passing parameter strings that contain special characters