Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
mindyckay
Partner - Contributor II
Partner - 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
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