search for a predefined list of values through all fields?

[#1]

Hi,

I need to add a drop down list with a predefined values und those values can be found on any of my fields.

For example I have 3 fields with product names:

fruits
orange
apple
melon

sweets
chocolate
apple pie
cookie

juice
orange juice
apple juice
cherry juice

These fields are dimensions in the pivot table. In my drop down list I select one certain value (e.g. apple)

drop down list
apple
orange
pine apple
.....

And then I want to see associated values in my pivot table highlighted(fruits - apple, sweets - apple pie, juice - apple juice )

This is similar to the standard search function, except that I need to select a value from a predefined list.

How can I achieve that?

Many thanks

[sunny_talwar]

Would you be able to share a sample to show your setup?

[MarcoWedel]

Hi,

maybe like this:

tabProductFacts:
LOAD RowNo() as ID, *,
    Ceil(Rand()*30) as SomeFact
FROM [https://community.qlik.com/thread/264763] (html, codepage is 1252, embedded labels, table is @1);
Concatenate
LOAD RowNo() as ID, *,
    Ceil(Rand()*30) as SomeFact
FROM [https://community.qlik.com/thread/264763] (html, codepage is 1252, embedded labels, table is @2);
Concatenate
LOAD RowNo() as ID, *,
    Ceil(Rand()*30) as SomeFact
FROM [https://community.qlik.com/thread/264763] (html, codepage is 1252, embedded labels, table is @3);

tabProducts:
CrossTable (ProductGroup, Product)
LOAD ID,
    fruits,
    sweets,
    juice
Resident tabProductFacts;
Join
LOAD Distinct
    Product,
    SubField(Product,' ') as [drop down list]
Resident tabProducts;

hope this helps

regards

Marco

[Sergey_Shuklin]

Hello, Alexandra!

It's cool when you can concatenate tables within the script and get you list of values, but if you can't you'll have to create a list of values from different separated fields. You can take a look for answer at this solved thread:

Dynamic Update of field depending on Selection

P.S.: Это прекрасно, если вы говорите по-русски