Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
mindyckay
New Contributor II

Passing parameter strings that contain special characters

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

1 Reply
MVP & Luminary
MVP & Luminary

Re: Passing parameter strings that contain special characters

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