topic Problem looking for values in QlikView https://community.qlik.com/t5/QlikView/Problem-looking-for-values/m-p/350340#M129826 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P>I prepared (File Attached) a details with What I want. </P><P>From two tables Btcc11 and Bsc01 I Exported it to excel and in excel I did this : </P><P>=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.</P><P></P><P>Thanks.</P></BODY></HTML> Fri, 13 Jul 2012 13:26:12 GMT pgalvezt 2012-07-13T13:26:12Z Problem looking for values https://community.qlik.com/t5/QlikView/Problem-looking-for-values/m-p/350340#M129826 <HTML><HEAD></HEAD><BODY><P>Hello, </P><P>I prepared (File Attached) a details with What I want. </P><P>From two tables Btcc11 and Bsc01 I Exported it to excel and in excel I did this : </P><P>=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.</P><P></P><P>Thanks.</P></BODY></HTML> Fri, 13 Jul 2012 13:26:12 GMT https://community.qlik.com/t5/QlikView/Problem-looking-for-values/m-p/350340#M129826 pgalvezt 2012-07-13T13:26:12Z Re: Problem looking for values https://community.qlik.com/t5/QlikView/Problem-looking-for-values/m-p/350341#M129827 <HTML><HEAD></HEAD><BODY><P>simply paste new column and paste expression:</P><P></P><P>=count (Monto_Protesto)</P><P></P><P>all the #N/A from Excell will by "0" in Qv chart</P></BODY></HTML> Fri, 13 Jul 2012 13:35:39 GMT https://community.qlik.com/t5/QlikView/Problem-looking-for-values/m-p/350341#M129827 2012-07-13T13:35:39Z Re: Problem looking for values https://community.qlik.com/t5/QlikView/Problem-looking-for-values/m-p/350342#M129828 <HTML><HEAD></HEAD><BODY><P>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. </P></BODY></HTML> Fri, 13 Jul 2012 13:48:02 GMT https://community.qlik.com/t5/QlikView/Problem-looking-for-values/m-p/350342#M129828 pgalvezt 2012-07-13T13:48:02Z Re: Problem looking for values https://community.qlik.com/t5/QlikView/Problem-looking-for-values/m-p/350343#M129829 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Thanks </P></BODY></HTML> Fri, 13 Jul 2012 14:00:42 GMT https://community.qlik.com/t5/QlikView/Problem-looking-for-values/m-p/350343#M129829 pgalvezt 2012-07-13T14:00:42Z Re: Problem looking for values https://community.qlik.com/t5/QlikView/Problem-looking-for-values/m-p/350344#M129830 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Anyone can help me with this requiriment I know is difficult. Its to bad that QlikView doesn't have a lookup Fuction.</P></BODY></HTML> Fri, 13 Jul 2012 14:20:28 GMT https://community.qlik.com/t5/QlikView/Problem-looking-for-values/m-p/350344#M129830 pgalvezt 2012-07-13T14:20:28Z