topic Re: Search in listbox in QlikView

Search in listbox

Wed, 28 May 2014 14:33:59 GMT

Hello,

I have a listbox with dates. The date format is DD-MM-YYYY. Normally if I select a month, I enter in the search box of the listbox the MM-YYYY. Then I can select the month. The problem I have is that this normally works, but I have one file, that it isn't possible to do this. Can someone help me with this, please?

With kind regards,

Aissam

Re: Search in listbox

datanibbler — Wed, 28 May 2014 14:43:46 GMT

Hi Aissam,

well, since you haven't attached or included any specific information, I can only make an assumption:

=> Maybe that table isn't properly linked.

Is there a date_field in that table? Try with that one (make sure it doesn't have the key_icon - fields with the key_icon behave a bit differently and can't be used for that kind of testing).

HTH

Best regards,

DataNibbler

Re: Search in listbox

Anonymous — Wed, 28 May 2014 14:49:11 GMT

Compare "default search mode" in the file that works and the file that doesn't work. It is in the list box properties, tab General

Re: Search in listbox

Wed, 28 May 2014 15:05:09 GMT

Script is:

MakeDate

(Mid(LABOR_TIME_COMPLT_LEFT,1,4),Mid(LABOR_TIME_COMPLT_LEFT,5,2),Mid(LABOR_TIME_COMPLT_LEFT,7,2)) as DayDateFinished,

Re: Search in listbox

Wed, 28 May 2014 15:11:10 GMT

checked, looks the same.

regards,

aissam

Re: Search in listbox

Wed, 28 May 2014 15:15:12 GMT

it doesn't use * * automatically? When I entered it works.

Re: Search in listbox

Anonymous — Wed, 28 May 2014 15:20:01 GMT

It is wildcard search mode...