Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
prathipsrinivas
Creator
Creator

Dynamic show/hide list box upon the selection of different list box

Hi Qlik Experts,

I have a requirement where I need to display all the fields in the model in a list box , that I have created using the field ($field).

Upon selection of field name in the list box created as in the above, listboxes for the selection has to be created.

For ex:

if I select one field name in the fields list box, new one list box for selected field should visible.

Similarly if I select 4 field names, that many list boxes has to be created.

Is there any way to achieve this? 

Thanks in advance,

Prathip

Prathip
Labels (4)
2 Solutions

Accepted Solutions
PrashantSangle

can you explain with sample data? with expected output.

Regards,
Prashant Sangle
Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

PrashantSangle

1: Create Inline table as ListBoxName which has value of all list box which you want to show / hide.
2: In front end give user to select this newly created inline
3: Take all List box in front end and Use below expression to show / hide list box
Expression :
1: For List Box A: If(GetFildSelections(ListBoxName)='A',1,0)
2: For List Box B: If(GetFildSelections(ListBoxName)='B',1,0)
3: For List Box C: If(GetFildSelections(ListBoxName)='C',1,0)

Regards,
Prashant Sangle
Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

5 Replies
PrashantSangle

can you explain with sample data? with expected output.

Regards,
Prashant Sangle
Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
prathipsrinivas
Creator
Creator
Author

Let's consider we have 5 fields in the model ,say

A,B,C,D,E.

I want a list box to display all the fields (A,B,C,D,E) as values.

When I select, say, A and C, I'd expect two new list boxed show up .

1 with Values of A and 2nd with values of C.

Hope the explanation is clear.

Prathip
PrashantSangle

1: Create Inline table as ListBoxName which has value of all list box which you want to show / hide.
2: In front end give user to select this newly created inline
3: Take all List box in front end and Use below expression to show / hide list box
Expression :
1: For List Box A: If(GetFildSelections(ListBoxName)='A',1,0)
2: For List Box B: If(GetFildSelections(ListBoxName)='B',1,0)
3: For List Box C: If(GetFildSelections(ListBoxName)='C',1,0)

Regards,
Prashant Sangle
Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
prathipsrinivas
Creator
Creator
Author

Thanks Prasanth.

Does it allow Multiple selection?

Prathip
PrashantSangle

yes.
Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂