Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
chrweber
Creator
Creator

Defining Value Separator for Input Boxes

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

2 Replies
chrweber
Creator
Creator
Author

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
Creator
Creator
Author

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.

<LocaleInfo>

     ....

    <ListSep>;</ListSep>

     ...

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:

Input Box and Concat