Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display listbox based on the selections from a common list box holding field name


Hi All,

Can anyone help me out with approach to get dynamic list box based on field selection.

Ex: I have a list box with all field names. Now once clicked  on any of the field in the list box a new list box should be visible holding selected field values.

Regards,

Prajna

10 Replies
rustyfishbones
Master II
Master II

Create a list box and dynamically show it based on the Field selection

Add this as a conditional option in Layout Tab

Count(DISTINCT FieldNames) = 1

the list box will only show if a selection is made in the FieldNames List Box

Not applicable
Author

Hi,

I have to create a list box and under layout I have to give Count(DISTINCT FieldNames) = 1 ????

Then what should be chosen for dimension and FieldNames referrred can be $(Field)??? or what exactly it signifies?

israrkhan
Specialist II
Specialist II

hi,

create a list box and on properties Layout>> Show, check conditional and put condition

=Count(DISTINCT YourFiledName) >= 1 , it Mean this list will be visible only when you will select 1 or more fields in other list, you dont need any dimension ,or any other step, try this and let us know, its works or not..

Not applicable
Author

Hi,

Now the main list box has say 10 field names. On click of each field name I should get a list box holding data for that particular field.

So in the exp =Count(DISTINCT YourFiledName) >= 1

yourFiledName holds what name??

Regards,

Prajna

israrkhan
Specialist II
Specialist II

the field name which you will select..

and You wrote " On click of each field name I should get a list box holding data for that particular field."

what type of data, or you mean the selected field name?

let me know in detail. your fields name. or if you can attach an example doc..

Not applicable
Author

for ex: I have field names likes this in a list box called list box1

list box1

Branch Name

Account Type

Now when I click on field Branch name.. A list box with Branch Name data should appear. As shown below

Branch Name

B1

B2

B3

B4

next on click of Account Type..  A list box with Account Type data should appear.


Not applicable
Author

Hi,

I would do:

1) Create a variable

vCurrentField:  =$(Field)   it is a formula

2) 1st list box:

Dimension: = $Field

3) 2nd ListBox:

The Expression:  =  $(=vCurrentField)


Fabrice

tresesco
MVP
MVP

May be like attached sample?

Not applicable
Author

hi..

I tried this em not getting any result

Regards,

Prajna