Problem looking for values

[pgalvezt]

Hello,

I prepared (File Attached) a details with What I want.

From two tables Btcc11 and Bsc01 I Exported it to excel and in excel I did this :

=BUSCARV(M2;'C:\Documents and Settings\pablo.galvez\Escritorio\[Export Bsc01.xls]Sheet1'!$D$1:$D$65536;1;FALSO) So Excel bring me the values associated from Bsc01. After that I didi a filter where all #N/A disappear. Its possible to do this in QlikView? For better comprehenssion I attached Details Files.

Thanks.

[#2]

simply paste new column and paste expression:

=count (Monto_Protesto)

all the #N/A from Excell will by "0" in Qv chart

[pgalvezt]

I can't do that because when I do the reload the QlikView file will be weight 20 MB. if this is ok for you I can do it.

[pgalvezt]

Thank for yor reply but the excel file is just an example that What I want to do in qlikview. The idea is looking for a value in the table bsc01 from btcc11 if qlikview found the value show me Monto protesto (is like a vlookup I think). I put excel files because Im Trying to explain what I want.

Thanks

[pgalvezt]

Hi,

Anyone can help me with this requiriment I know is difficult. Its to bad that QlikView doesn't have a lookup Fuction.