topic lookup in QlikView

lookup

srujanaponnuru — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: lookup

sunny_talwar — Mon, 23 Jul 2018 13:38:30 GMT

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

Re: lookup

srujanaponnuru — Mon, 23 Jul 2018 13:41:07 GMT

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

that expression I need to write in apply map

Re: lookup

sunny_talwar — Mon, 23 Jul 2018 13:46:00 GMT

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....

Re: lookup

Anil_Babu_Samineni — Mon, 23 Jul 2018 13:46:34 GMT

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;

Re: lookup

Anonymous — Mon, 23 Jul 2018 14:13:20 GMT

Please provide complete logic which you are using in excel