Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

samane_ramezani
Contributor

Sequence in list boxes show

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.

a.png

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: Sequence in list boxes show

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

View solution in original post

2 Replies
MVP & Luminary
MVP & Luminary

Re: Sequence in list boxes show

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

View solution in original post

samane_ramezani
Contributor

Re: Sequence in list boxes show

Thank u very much Marcus

I prepared what I wanted with your guidance