topic Re: Show multiple text object(Images) from single selected value in QlikView

Show multiple text object(Images) from single selected value

weijietc — Thu, 05 Nov 2015 10:33:20 GMT

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.

Re: Show multiple text object(Images) from single selected value

Gysbert_Wassenaar — Thu, 05 Nov 2015 17:23:21 GMT

Green: MinString(Colors)

Red: Maxstring(Colors)

Won't work with three possible values though.

Re: Show multiple text object(Images) from single selected value

Thu, 05 Nov 2015 17:31:28 GMT

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

Re: Show multiple text object(Images) from single selected value

weijietc — Fri, 06 Nov 2015 00:56:15 GMT

I tried, it work for two possible values.

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

Re: Show multiple text object(Images) from single selected value

weijietc — Fri, 06 Nov 2015 01:04:38 GMT

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)

Re: Show multiple text object(Images) from single selected value

marcus_sommer — Fri, 06 Nov 2015 11:49:50 GMT

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

Re: Show multiple text object(Images) from single selected value

Gysbert_Wassenaar — Fri, 06 Nov 2015 13:26:53 GMT

Yeah, the way Marcus_Sommer described:

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

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

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

etc