lookup

[srujanaponnuru]

hi,

I have requirement in excel with formula :

(IF(OR(VLOOKUP(X11,$XFA$5:$XFB$76,2,0)="BAD",AND(VLOOKUP(X11,$XFA$5:$XFB$76,2,0)="OK"

how do we write this statement using Applymap in qlikview.

please help

[sunny_talwar]

Can you share the Excel file where you are using this?

[srujanaponnuru]

sorry I cant share the excel file as it is confidential for client it seems.

that expression I need to write in apply map

[sunny_talwar]

No where close to being an expert in Excel... so don't know what it is doing to help you with what it might be in QlikView... can you mock it up with some dummy data... I just need to see the logic of what it might be doing in Excel....

[Anil_Babu_Samineni]

May be this?

If the field comes from same table and from different table and having same column field from two tables. You may try this way?

Mapping:

Mapping Load X11, Common_Field From Table;

Table:

Load If(ApplyMap('Mapping',XFA,'NA') or ApplyMap('Mapping',XFB,'NA'),'BAD', If(ApplyMap('Mapping',XFA,'NA') and ApplyMap('Mapping',XFB,'NA'),'OK')) as FieldName;

[Anonymous]

Please provide complete logic which you are using in excel