topic URGENT: Trouble connecting Excel Data in QlikView https://community.qlik.com/t5/QlikView/URGENT-Trouble-connecting-Excel-Data/m-p/557458#M1144029 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have to present this dashboard on Monday and need help in trying to fix this issue I'm having.</P><P></P><P>The table diagram is attached.</P><P></P><P>"Preparer Grade" in table "Active File Query" and "Grade Value (P)" in the table "Preparer Grades" are the same thing.</P><P><BR />Difference is that I have manually done a vlookup in Excel and added the values in Active Files Query sheet. This is the data I want to show in charts without having to do a vlookup.</P><P><BR />The vlookup is between the Preparer Notes Address and FSLI. Qlikview isn't counting all the values as you can see in the attached image but the manual vlookup column "Preparer Grade" is. Please help.</P><P></P><P>Kind regards,</P></BODY></HTML> Sat, 31 Aug 2013 17:28:27 GMT 2013-08-31T17:28:27Z URGENT: Trouble connecting Excel Data https://community.qlik.com/t5/QlikView/URGENT-Trouble-connecting-Excel-Data/m-p/557458#M1144029 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have to present this dashboard on Monday and need help in trying to fix this issue I'm having.</P><P></P><P>The table diagram is attached.</P><P></P><P>"Preparer Grade" in table "Active File Query" and "Grade Value (P)" in the table "Preparer Grades" are the same thing.</P><P><BR />Difference is that I have manually done a vlookup in Excel and added the values in Active Files Query sheet. This is the data I want to show in charts without having to do a vlookup.</P><P><BR />The vlookup is between the Preparer Notes Address and FSLI. Qlikview isn't counting all the values as you can see in the attached image but the manual vlookup column "Preparer Grade" is. Please help.</P><P></P><P>Kind regards,</P></BODY></HTML> Sat, 31 Aug 2013 17:28:27 GMT https://community.qlik.com/t5/QlikView/URGENT-Trouble-connecting-Excel-Data/m-p/557458#M1144029 2013-08-31T17:28:27Z Re: URGENT: Trouble connecting Excel Data https://community.qlik.com/t5/QlikView/URGENT-Trouble-connecting-Excel-Data/m-p/557459#M1144030 <HTML><HEAD></HEAD><BODY><P>Attach the excel file and the qvw that doesn't count.</P></BODY></HTML> Sat, 31 Aug 2013 21:46:47 GMT https://community.qlik.com/t5/QlikView/URGENT-Trouble-connecting-Excel-Data/m-p/557459#M1144030 luciancotea 2013-08-31T21:46:47Z