Sequence in list boxes show

Anonymous — Sun, 31 Dec 2017 13:17:18 GMT

Hi Qlikers

I have a Super Field that contain several Fields as like as A,B,C,D.

each A,B,C,D has their own value as like as 1,2,3,...

when I select A and B filed I want to have report whit list boxes A and B

and

if I select B,C,D I want to have report whit list boxes B,C and D.

Re: Sequence in list boxes show

marcus_sommer — Mon, 01 Jan 2018 10:06:01 GMT

I'm not quite sure what do you want to do. Normally you could create all listboxes which you need and if they are too many you could instead use multiboxes or table-charts and/or container for them all.

Of course a control of their visibility is also possible within the object-properties in tab layout maybe just with something like:

wildmatch(getfieldselections(SuperFiled), '*A*')

But in this way you won't be able to control the displayed order of the listboxes and may lay over eachother. This meant you would need to grab the fields dynamically for the list of selected values of the SuperFiled. This could be done with a $-sign expansion like:

=[$(=subfield(concat(SuperFiled, ','), ',', 1))]

and the visibility-condition might be:

=len(subfield(concat(SuperFiled, ','), ',', 1))

This approach might need to be extended to catch the case if no value of SuperFiled is selected by adding a check of getselectedcount() to the visibility-condition and also adding a third (order) parameter to the concat-function /maybe through an additionally orderfield) because otherwise the values would be sorted alphanumeric.

- Marcus

Re: Sequence in list boxes show

Anonymous — Tue, 02 Jan 2018 06:05:19 GMT

Thank u very much Marcus

I prepared what I wanted with your guidance

topic Re: Sequence in list boxes show in QlikView

Sequence in list boxes show

Re: Sequence in list boxes show

Re: Sequence in list boxes show