topic Re: Create listbox based on concatenation of string & value selected in another listbox in QlikView

Create listbox based on concatenation of string & value selected in another listbox

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have a listbox titled Category with with values B and M. In my data I have 4 columns B_Country, B_Region, M_Country, M_Region.

I want to create a dynamic listbox which will show countries belonging to B_Country for B_Region = 'EU' when B is selected in listbox titled Category.The same logic applies when I select M.

I created a listbox and defined the rule in field expression as: =If('$(=Category)'&'_Region' = 'EU', '$(=Category)'&'_Country')

But it's not working.

Can you please help me in resolving this?

Regards,

Ayandeep

Re: Create listbox based on concatenation of string & value selected in another listbox

Peter_Cammaert — Thu, 20 Apr 2017 14:20:52 GMT

I'm not entirely sure what the IF condition is for, but try to create a real field name in the THEN part, instead of a string.

=If([$(=Category)_Region] = 'EU', [$(=Category)_Country])

Nevermind the warnings that the expression editor will give you. Both the syntax checker in the Script Editor as well as the one in the Expression editor are incapable of handling live field name deduction.

[Edit] Fixed the IF condition as well, since it had the same problem

Re: Create listbox based on concatenation of string & value selected in another listbox

Thu, 20 Apr 2017 15:11:20 GMT

Hi Peter,

I tried using the expression you have mentioned but unfortunately it's not working.

Regards,

Ayandeep

Re: Create listbox based on concatenation of string & value selected in another listbox

Anonymous — Thu, 20 Apr 2017 15:14:56 GMT

Could you post a sample data?

Re: Create listbox based on concatenation of string & value selected in another listbox

Thu, 20 Apr 2017 15:23:55 GMT

Attached sample data

Re: Create listbox based on concatenation of string & value selected in another listbox

Anonymous — Thu, 20 Apr 2017 15:41:07 GMT

Will this do??

=if(GetFieldSelections(Category)= 'Booked' and [Booked Region] = 'Europe',[Booked Country],if(GetFieldSelections(Category)= 'Managed' and [Booked Region] = 'Europe',[Managed Country]))

Re: Create listbox based on concatenation of string & value selected in another listbox

Thu, 20 Apr 2017 15:47:25 GMT

Thanks a lot it works.

Re: Create listbox based on concatenation of string & value selected in another listbox

Anonymous — Thu, 20 Apr 2017 15:57:50 GMT

May be like this

Re: Create listbox based on concatenation of string & value selected in another listbox

Thu, 20 Apr 2017 16:04:05 GMT

Once I download the file the solution doesn't show somehow. Can you please explain it in text.

Re: Create listbox based on concatenation of string & value selected in another listbox

MarcoWedel — Thu, 20 Apr 2017 21:19:15 GMT

please try not to open multiple threads for the same question:

Create listbox based on value selected in another listbox

thanks

regards

Marco

Re: Create listbox based on concatenation of string & value selected in another listbox

Anonymous — Fri, 21 Apr 2017 07:59:27 GMT

Ah ok no problem.

I use this following expression:

=If( GetFieldSelections([Booked Region])='Europe' or GetFieldSelections(Category)='Booked',Category&'_'&[Booked Country]

,If( GetFieldSelections([Managed Region])='Europe' or GetFieldSelections(Category)='Managed',Category&'_'&[Managed Country] ))

Re: Create listbox based on concatenation of string & value selected in another listbox

Fri, 21 Apr 2017 08:07:44 GMT

Assign your expression to one variable and re use the variable in listbox by using expression option