topic Re: Defining Value Separator for Input Boxes in QlikView

Defining Value Separator for Input Boxes

chrweber — Thu, 12 Apr 2018 17:24:17 GMT

How can I define the separator for inputboxes.

I've had a document where the values where separated by semicolon and by comma.

I wish to separate them by semicolon.

How can I do this?

Best

Regards

chrweber — Thu, 12 Apr 2018 17:34:05 GMT

It appears that I want to know how to change the document list seprator.

I tried setting

SET ListSep =';';

in the load script but to no effect

chrweber — Fri, 13 Apr 2018 03:41:42 GMT

Qlikview appears to adopt the sList from Computer\HKEY_CURRENT_USER\Control Panel\International

That means editing this key and then opening a new document will work.

Check CTRL+SHIFT+Q: ListSep

Editing the document token however appears not possible withing Qlikview itself.

Instead, you have to create a Projectfolder: <QVWname>-prj, save the file and then edit DocProperties.xml

Search for ListSep and edit.

....

...

I hope to get some official feedback on this or maybe a link if that solution has already been posted.

The following Link is not satisfactory: