topic Find a selected value in a list in QlikView https://community.qlik.com/t5/QlikView/Find-a-selected-value-in-a-list/m-p/365825#M136107 <HTML><HEAD></HEAD><BODY><P>evason75,</P><P></P><P>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:</P><P></P><P>=IF(count({&lt;Veg=Fruit &gt;} Veg)&gt;0,'Yes this appears in the Veg list', 'No this does not appear')</P></BODY></HTML> Wed, 23 May 2012 15:09:51 GMT swuehl 2012-05-23T15:09:51Z Find a selected value in a list https://community.qlik.com/t5/QlikView/Find-a-selected-value-in-a-list/m-p/365824#M136106 <HTML><HEAD></HEAD><BODY><P>This is driving me crazy. I know it's straight forward, but my mind is blank.</P><P></P><P>I have 2 unrelated tables. One Fruit the other Veg.</P><P></P><P>When i select a fruit i want to know if it appears in the Veg list and return is in a textbox.</P><P></P><P>I have attached a qvw to display what i mean.</P><P></P><P>I thought it was =IF(Match(GetFieldSelections(Fruit),Veg)&gt;0,'Yes this appears in the Veg list', 'No this does not appear')</P></BODY></HTML> Wed, 23 May 2012 15:02:13 GMT https://community.qlik.com/t5/QlikView/Find-a-selected-value-in-a-list/m-p/365824#M136106 Anonymous 2012-05-23T15:02:13Z Find a selected value in a list https://community.qlik.com/t5/QlikView/Find-a-selected-value-in-a-list/m-p/365825#M136107 <HTML><HEAD></HEAD><BODY><P>evason75,</P><P></P><P>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:</P><P></P><P>=IF(count({&lt;Veg=Fruit &gt;} Veg)&gt;0,'Yes this appears in the Veg list', 'No this does not appear')</P></BODY></HTML> Wed, 23 May 2012 15:09:51 GMT https://community.qlik.com/t5/QlikView/Find-a-selected-value-in-a-list/m-p/365825#M136107 swuehl 2012-05-23T15:09:51Z