Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

smitaranikr04
Not applicable

lookup

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

1 Solution

Accepted Solutions
Not applicable

Re: lookup

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

4 Replies
marcus_malinow
Not applicable

Re: lookup

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

Not applicable

Re: lookup

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

smitaranikr04
Not applicable

Re: lookup

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

smitaranikr04
Not applicable

Re: lookup

Thanx Ken.