topic Re: Listbox problem in QlikView

Listbox problem

AH — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

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

Country

USA

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

Re: Listbox problem

Lisa_P — Thu, 26 Apr 2018 01:40:58 GMT

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.

Re: Listbox problem

Anonymous — Thu, 26 Apr 2018 05:33:40 GMT

Hi,

write below expression in field <expression of list box>

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

Re: Listbox problem

sudhirpkuwar — Thu, 26 Apr 2018 06:08:11 GMT

Hi,

Can you give the expected output...

Re: Listbox problem

AH — Thu, 26 Apr 2018 19:24:31 GMT

Thanks a Lot Aruna!

Regards,