Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Would you be able to share a sample to show your setup?
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
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.: Это прекрасно, если вы говорите по-русски