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: 
AH
Creator III
Creator III

Listbox problem

Hi,

Lets say I have a listbox and its showing values like this:

Country

USA

UK

UAE

KSA

ITA

Now i would like to make the listbox behave like this way:

I would like to show only 'USA' value in the country list Box. But when the 'USA' value is not checked/Selected then It will show the values corresponding other countries to other fields by association. But when 'USA' value is checked then Country field shows the 'USA' value is selected and values corresponding to 'USA' to other fields shows by association.

Thanks & regards

1 Solution

Accepted Solutions
arunaerra
Partner
Partner

Hi,

write below expression in field <expression of list box>

=if(Country]='USA',[Customer Country])


list.PNG

View solution in original post

4 Replies
Lisa_P
Employee
Employee

On the General tab of the List box properties, you can tick the Hide Excluded option to only show the selected or associated/possible values.

arunaerra
Partner
Partner

Hi,

write below expression in field <expression of list box>

=if(Country]='USA',[Customer Country])


list.PNG

View solution in original post

sudhirpkuwar
Partner
Partner

Hi,

Can you give the expected output...

AH
Creator III
Creator III
Author

Thanks a Lot Aruna!

Regards,