Passing parameter strings that contain special characters

[mindyckay]

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&bookmar...http://qlikviewdev.com/QvAJAXZfc/opendoc.htm?document=Test%20Ad%20Hoc.qvw&host=QVS%40testqv1&bookmar...=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):

CC

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

[marcus_sommer]

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