topic Re: lookup in QlikView

lookup

Anonymous — Fri, 04 Oct 2013 12:58:18 GMT

Hi Guys,

I have two column A and B

A B C

1 a N/A
2 1 1

3 c N/A

4 2 2

5 d N/A

Now i need to calculate a field C where it will check row wise like B column first row value is a, it will search a in full A column and if it finds the same value it should return a or else n/a.

PLEASE HELP ME ON THIS

Re: lookup

marcus_malinow — Fri, 04 Oct 2013 13:47:11 GMT

Hi Rajashmita,

this sounds like the sort of issue that ApplyMap could resolve.

To build your mapping table

MappingTable:

MAPPING LOAD

A, A

FROM .....

Then user it like this

ApplyMap('MappingTable', B, 'N/A')

Steve Dark did a great blog post on ApplyMap - http://www.quickintelligence.co.uk/applymap-is-it-so-wrong/

Marcus

Re: lookup

Fri, 04 Oct 2013 14:26:48 GMT

I was able to accomplish this using the load script in the attached QVW.

Re: lookup

Anonymous — Tue, 22 Oct 2013 05:27:52 GMT

Hi Marcus thanx a lot for your suggestion. It works fine

Re: lookup

Anonymous — Tue, 22 Oct 2013 05:28:14 GMT

Thanx Ken.