topic Re: List Separator in QlikView

List Separator

Mon, 24 Mar 2014 19:44:29 GMT

my document and system listsep is ',' (comma).

now i have requirement where my inputbox dropdown will contain customer names with ',' (lastname, firstname). selecting this name should select this customer.

currently i have a work around in my design to takeout ',' while displaying the inputbox dropdown and after selecting customer user will have to click on a button (placing the ',' back) will select the customer. which works but with expense of one additional button click, which we are trying to eliminate this with variable trigger in place.

now i am trying to change the listsep value in the system control panel from ',' to ';', recopy the application will only changing my 'sys' list sep but not the 'Doc' list sep. (brand new document will take the ';' as doc and sys listsep)

Question is, is there a way to change the Document List separator either in the script or one time macro command ?

Re: List Separator

Anonymous — Mon, 24 Mar 2014 19:52:23 GMT

below is directly from this thread: Input Box and Concat

Hi there,

It seems it takes (and preserve) this setting from the original operating system. Go to the Windows Start button, Control Panel, Regional Settings, Additional Customization, and there you have in the "Number" tab all the locale settings for date, decimal, thousand and yes, list separator.

Pretty easy to mess that up when you download a file created in a different operating system language, as it happens here.

As far as I've tried, there is no similar setting/environment variable in QlikView that you can set.

Hope that makes sense.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

EDIT: It can be changed as well in the registry browsing to the key HKEY_CURRENT_USER\Control Panel\International and the String entry (Windows 7) "sList" with value ";" or whatever.

Re: List Separator

Anonymous — Mon, 24 Mar 2014 19:55:08 GMT

First, I was sure that separator is always ':' - this is what Help says. Anyway, no matter what it is, any separator works if you put each value in the single quotes, i.e. 'lastname, firstname','lastname, firstname'

Re: List Separator

Anonymous — Mon, 24 Mar 2014 19:55:11 GMT

check this thread...Miguel Angel Baeyens has a solution for your question!

Input Box and Concat

Re: List Separator

Mon, 24 Mar 2014 20:04:51 GMT

tried with single quotes but it still spitting the name at comma.

my input is : 'JOHN, SMITH','KEVIN, STUART'

output:

'JOHN

SMITH'

'KEVIN

STUART'

Re: List Separator

Mon, 24 Mar 2014 20:06:55 GMT

Miguel's solutions is the same what i am doing i believe, if you change the system variable on control panel it only applys to new documents. but it will not change existing document document list separator even after reload.

Re: List Separator

Anonymous — Mon, 24 Mar 2014 20:13:50 GMT

Strange, I tested. Used ';' as separator. Listed value:

'1;2;3';'456';'789'

And, the first value in drop-down is '1;2;3', not the '1

What gives me a pause - my "document support info" says that ListSep =",", but I always use ";", because of this:

Listed Values

Check this alternative to specify a list of arbitrary predefined values. The values can be either numeric or alphanumeric. Alphanumeric values must be enclosed in quotes (e.g. 'abc'). Each value is separated by a semicolon ( ; ) (e.g. 'abc';45;14.3;'xyz' ). This option can be used alone or in combination with Number
Series.

Did you try ";"?

Re: List Separator

Mon, 24 Mar 2014 21:18:26 GMT

thats weird ... i tried with semicolon also, didn't work. my values are out of an expression, did you try hard coded values in the input box ? will it make any difference ?

Re: List Separator

Anonymous — Tue, 25 Mar 2014 00:10:25 GMT

Yes, I tried only hardcoded. This is the exact string I've typed there:

'1;2;3';'456';'789'

Can you upload non-working example?

Re: List Separator

Thu, 09 Jun 2016 10:24:57 GMT

Anyone have a solution yet, as Srinivas states it is fine for new documents but not on existing models. it it is reflecting you should be able to change the document setting, even if it is via a script

Re: List Separator

chrweber — Fri, 13 Apr 2018 03:34:58 GMT

I have found the solution of editing the ListSep of Existing Documents.

A rather unworthy one.

I hope that there is a more explicit one.

Defining Value Separator for Input Boxes