topic Re: Input Box and Concat in QlikView

Input Box and Concat

qlikconsult — Mon, 22 Aug 2011 08:48:52 GMT

Previously I was able to use the function = concat( Distinct Company, ',' ) in a inputbox's Listed Values text box on the Constraints tab.

This allowed me to show all the different company names as drop-down values in the input box.

When I try to do this now (currently in version 10, SR2), it show the drop-down values all in one row, for example Company1,Company2,Company3 etc. (see screenshot below). I also tried it using another delimiter ; in the function, but this also gave the same problem = concat( Distinct Company, ';' )

I would appreciate it if someone had an idea / example of how I should go about to do this.

Thank you

Jan-Hendrik

Re: Input Box and Concat

Miguel_Angel_Baeyens — Mon, 22 Aug 2011 09:15:09 GMT

Hello Jan-Hendrik,

Use the following instead in the "Listed Values" expression dialog in the object properties, "Constraints" tab as in the attached example:

=Concat(DISTINCT Field, ';')

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Input Box and Concat

qlikconsult — Mon, 22 Aug 2011 13:13:52 GMT

Hi Miguel

Thank you for the feedback. This however did not solve my problem, I still get only one value in drop-down box showing:

Value A, Value B, Value C

Thus values show next to each other opposed to underneath each other.

When I use your document however it works correctly on my computer. Thus I'm wondering whather is isn't a setting on the document which need to be changed or alternatively it could be a bug.

Any ideas from someone

Thank you

Input Box and Concat

qlikconsult — Mon, 22 Aug 2011 13:14:35 GMT

Hi Miguel

Thank you for the feedback. This however did not solve my problem, I still get only one value in drop-down box showing:

Value A, Value B, Value C

Thus values show next to each other opposed to underneath each other.

When I use your document however it works correctly on my computer. Thus I'm wondering whather is isn't a setting on the document which need to be changed or alternatively it could be a bug.

Any ideas from someone

Thank you

Input Box and Concat

qlikconsult — Mon, 22 Aug 2011 13:16:35 GMT

Hi Miguel

Thank you for the feedback. This however did not solve my problem, I still get only one value in drop-down box showing:

Value A, Value B, Value C

Thus values show next to each other opposed to underneath each other.

When I use your document however it works correctly on my computer. Thus I'm wondering whather is isn't a setting on the document which need to be changed or alternatively it could be a bug.

Any ideas from someone

Thank you

Input Box and Concat

qlikconsult — Mon, 22 Aug 2011 13:37:03 GMT

Sorry, above should read

Value A;Value B;Value C

Re: Input Box and Concat

Miguel_Angel_Baeyens — Mon, 22 Aug 2011 14:37:55 GMT

How did you create the variable? Is it in the load script? Did you do that in the Variable Overview in the Settings menu? In case is might be a bug, have you tried with the latest revision of QV 10 SR3 (build 9061) before contacting to the Support guys? Is there any chance you can upload your non-working document so we can check further?

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

P.S.: I wouldn't mark as helpful a reply when it is not actually helpful. It may mislead another people with a similar issue looking for help.

Input Box and Concat

qlikconsult — Tue, 23 Aug 2011 17:20:23 GMT

Hi Miguel

Thx for your further correspondence

I tried both adding variable in >> Settings >> Variable Overview as well as in load script.

I also upgraded to QV10 SR3 (build 9061).

In both cases I get the same problem.

Link to example doc:

InputBoxConcat.qvw

Thank you for your assistance so far.

Jan-Hendrik

Re: Input Box and Concat

qlikconsult — Tue, 23 Aug 2011 17:24:25 GMT

Sorry, find attached example file, previous method not correct

Re: Input Box and Concat

Miguel_Angel_Baeyens — Tue, 23 Aug 2011 18:12:27 GMT

Ok, got it. Get to the Help menu, click on the "Document Support Info". A dialog with information about your document and environment appears. You will see there "List Separator" the Sys preference, in my case, is set to ";" whilst Doc in your case is set to ".". So type instead

=Concat(Field, '.')

And the values will appear as expected.

Regards.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Input Box and Concat

rwunderlich — Tue, 23 Aug 2011 18:22:02 GMT

Thanks Miguel. The concat/inputbox issue has been a mystery to me for years.

Any idea where the Document ListSep gets set?

-Rob

Re: Input Box and Concat

Miguel_Angel_Baeyens — Tue, 23 Aug 2011 18:32:30 GMT

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: Input Box and Concat

qlikconsult — Tue, 23 Aug 2011 21:08:27 GMT

Thank you Miguel, you have solved a major headache for me.

Send me your residential address to my Qlikview community message inbox and I'll send you a bottle or two delicious South African wine.

Best regards,

Jan-Hendrik