topic Re: Match and Pick a column value in QlikView

Match and Pick a column value

sai_katare — Sat, 16 Nov 2024 19:29:53 GMT

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.

Re: Match and Pick a column value

tresB — Mon, 09 Dec 2019 11:09:12 GMT

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

Re: Match and Pick a column value

Anil_Babu_Samineni — Mon, 09 Dec 2019 11:12:50 GMT

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

If(Item = Item_v, Region)

Re: Match and Pick a column value

Brett_Bleess — Tue, 17 Dec 2019 16:43:33 GMT

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