Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
AH
Contributor 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

Tags (1)
1 Solution

Accepted Solutions
Partner
Partner

Re: Listbox problem

Hi,

write below expression in field <expression of list box>

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


list.PNG

View solution in original post

4 Replies
Employee
Employee

Re: Listbox problem

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.

Partner
Partner

Re: Listbox problem

Hi,

write below expression in field <expression of list box>

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


list.PNG

View solution in original post

Partner
Partner

Re: Listbox problem

Hi,

Can you give the expected output...

AH
Contributor III

Re: Listbox problem

Thanks a Lot Aruna!

Regards,