Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
samane_ramezani
Creator
Creator

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
marcus_sommer
MVP & Luminary
MVP & Luminary

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
marcus_sommer
MVP & Luminary
MVP & Luminary

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
Creator
Creator
Author

Thank u very much Marcus

I prepared what I wanted with your guidance