Show multiple text object(Images) from single selected value

[weijietc]

I have selected Apple from Fruits list box.

Can i display the associated values (Green and Red) as two different text object(Images)? How?

Thanks in advance.

[Gysbert_Wassenaar]

Green: MinString(Colors)

Red: Maxstring(Colors)

Won't work with three possible values though.

[#3]

what is it you are trying to accomplish? - the concept of the white, showing what is related to what is selected, is a key feature of QlikView

[weijietc]

I tried, it work for two possible values.

Is there any other way to do it for three possible values or more?

[weijietc]

I am trying to display all the values which are related to what is selected as text object(Images).

I have a scenario where select an organization name from list box.

Then it should display all of the top level management person images. (For example 5 person images)

[marcus_sommer]

You could get with concat(distinct Colors, ',') a list of the possible values from this field depending of any selection which is made within these application. Those list could be counted per substringcount() and divided per subfield() to make visibilty-conditions on multiple textboxes and define their value/image.

But this could be reached easier if you used a table-chart which could display images as expression-interpretation. Within the qv demo-documents in your install-folder is a good example for this: Presidents.qvw and this might be helpful, too: Loading Images into QlikView.

- Marcus

[Gysbert_Wassenaar]

Yeah, the way Marcus_Sommer described:

subfield(concat(distinct Colors, '|'), '|',1)

subfield(concat(distinct Colors, '|'), '|',2)

subfield(concat(distinct Colors, '|'), '|',3)

etc