Listbox search in more than one field

[Anonymous]

Hello,

  Is there a way to create a Listbox that can search in more than one field?

  I have 5 columns:

  Col1, Col2, Col3, Col4, Col5

  I'd like to create a Listbox that shows all the possible values of Col1...Col5 and can find any of those values in any fields

  is it possible?

thanks

[MK_QSL]

Why can't you use Search object?

[Anonymous]

Checkbox selecting is a client requierement

[MK_QSL]

Create a list box using below expression..

=ValueList(

  $(=

  Concat(Distinct chr(39)&Col1&chr(39),',') & ',' &

  Concat(Distinct chr(39)&Col2&chr(39),',') & ',' &

  Concat(Distinct chr(39)&Col3&chr(39),',') & ',' &

  Concat(Distinct chr(39)&Col4&chr(39),',') & ',' &

  Concat(Distinct chr(39)&Col5&chr(39),',') & ',' &

  )

  )

[MK_QSL]

or use this..

QlikView App: Multi Column List Box

[Anonymous]

it displays all the possible values between Col1 and Col5, but when I click it, it just do nothing

What could I be doing wrong?

Thankss!!!!!

[marcus_sommer]

Beside the suggestion from Manish you could activate all listboxes (by using the shift-key and left-clicks an the caption or with a lasso-selection) and then just typing your search-value and it will search in all listboxes at the same time.

Another possibility would be to use the advanced search - if you activate a listbox and starts typing you will get a search-window and on the left will be your typed chars and on the right you will see a >> icon - if you clicked on them you get the advanced search which will work like the searchbox (and like within there you could limit within the search-settings from the listbox in which fields should be searched - it's most a good idea to limit these feature then otherwise the search will run against the whole datamodel which could be rather slow).

- Marcus

[johnw]

There's a small chance this will work for you as a list box expression.

=pick(match($Field,'Col1','Col2','Col3','Col4','Col5'),Col1,Col2,Col3,Col4,Col5)

It will list all distinct values of your fields in the list box. But in order to select a value, that value must only appear in one of the fields. Otherwise you can click on it, but nothing will happen. If it does appear in only one of the fields, it will select that value from that field, but also select all compatible values in the other four fields, and without showing them as selected in your list box. If only one of the columns is ever filled in at a time, then it only selects values in the field that has that value. But even then, the list box doesn't clear properly if you clear the underlying field rather than clearing the list box. A clear all still works.

So probably not very useful except in very specific cases.

[MarcoWedel · Accepted solution]

Hi,

maybe one solution could be a combined field generated by a crosstable load:

table1:
LOAD RecNo() as ID,
    'Col1Value'&Ceil(Rand()*4) as Col1,
    'Col2Value'&Ceil(Rand()*4) as Col2,
    'Col3Value'&Ceil(Rand()*4) as Col3,
    'Col4Value'&Ceil(Rand()*4) as Col4,
    'Col5Value'&Ceil(Rand()*4) as Col5,
    Ceil(Rand()*100) as SomeFact
AutoGenerate 20;

tabCol:
CrossTable (Col, ColValue)
LOAD ID, Col1, Col2, Col3, Col4, Col5
Resident table1;

hope this helps

regards

Marco

[Anonymous]

Thanks!!!!!!!!!!! it was very useful, worked perfect!!!!!!