Solved: Find a selected value in a list - Qlik Community

Anonymous · ‎2012-05-23

This is driving me crazy. I know it's straight forward, but my mind is blank.

I have 2 unrelated tables. One Fruit the other Veg.

When i select a fruit i want to know if it appears in the Veg list and return is in a textbox.

I have attached a qvw to display what i mean.

I thought it was =IF(Match(GetFieldSelections(Fruit),Veg)>0,'Yes this appears in the Veg list', 'No this does not appear')

swuehl · ‎2012-05-23

evason75,

Veg is not a list of strings you can use in the match() function. You can work out a solution using concat to create a list of values from your field or try:

=IF(count({<Veg=Fruit >} Veg)>0,'Yes this appears in the Veg list', 'No this does not appear')

View solution in original post

swuehl · ‎2012-05-23

evason75,

Veg is not a list of strings you can use in the match() function. You can work out a solution using concat to create a list of values from your field or try:

=IF(count({<Veg=Fruit >} Veg)>0,'Yes this appears in the Veg list', 'No this does not appear')