Match and Pick a column value

[sai_katare]

Hi,

I am stuck with the following situation and need help

1. I have 3 columns 'Item', 'Item_v' and 'Region'

2. I need to do something like... if a value in 'Item_v' exists in 'Item' then pick 'Region' from 'Item'

basically I am trying to match a string in 'Item_v' with 'Item' and pickup 'Region' from 'Item' if exists.

How do I achieve this?

Thanks in advance. 

[tresesco]

It becomes easier for people here to understand your problem if you could explain with an example/sample data set.

[Anil_Babu_Samineni]

May be simply doing If..Else statement? I apologies If i misread the question.

If(Item = Item_v, Region)

[Brett_Bleess]

The only other thing I can offer is a link to the Design Blog area where you will find many how-to items posted there:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

If Anil's post did help, be sure to use the Accept as Solution button on his post to give him credit for the help, otherwise, leave an update if you still are searching for additional help and the above link does not get you anything that helps either.

Regards,
Brett