topic Re: Read From Diffrent Execl Sheet in QlikView https://community.qlik.com/t5/QlikView/Read-From-Diffrent-Execl-Sheet/m-p/1291008#M861416 <HTML><HEAD></HEAD><BODY><P>Hi Mario,</P><P></P><P>Your problem, If I´ve understood correctly, it´s that you have two origins with differents values but similar names.</P><P></P><P>Qualify change <SPAN lang="en">automatically</SPAN> names of fields. If you want to know more about it please read this document <A href="https://community.qlik.com/docs/DOC-7963">Do you Qualify?- How to use QUALIFY statement</A>.</P><P></P><P>Regards</P><P></P><P>Miguel del Valle de Gracia</P></BODY></HTML> Mon, 09 Jan 2017 10:39:32 GMT migueldelval 2017-01-09T10:39:32Z Read From Diffrent Execl Sheet https://community.qlik.com/t5/QlikView/Read-From-Diffrent-Execl-Sheet/m-p/1291005#M861413 <HTML><HEAD></HEAD><BODY><P>Dear all ,</P><P></P><P>Kindly i need to read from 2 excel sheet , each excel sheet has the target of each year .</P><P></P><P>The first excel sheet is name Target-2016 and the second is Target-2016 i am using this target on single KPI</P><P></P><P>How can i read these two sheet without concatenation since i am you going to add a target next year as well.</P><P></P><P>Thank you.</P><P>Hope you can help </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Read-From-Diffrent-Execl-Sheet/m-p/1291005#M861413 mario-sarkis 2020-11-25T16:16:04Z Re: Read From Diffrent Execl Sheet https://community.qlik.com/t5/QlikView/Read-From-Diffrent-Execl-Sheet/m-p/1291006#M861414 <HTML><HEAD></HEAD><BODY><P>Hi Mario,</P><P></P><P>You can use qualify to have both excel sheets.</P><P></P><P>Regards</P><P></P><P>Miguel del Valle</P></BODY></HTML> Mon, 09 Jan 2017 09:15:30 GMT https://community.qlik.com/t5/QlikView/Read-From-Diffrent-Execl-Sheet/m-p/1291006#M861414 migueldelval 2017-01-09T09:15:30Z Re: Read From Diffrent Execl Sheet https://community.qlik.com/t5/QlikView/Read-From-Diffrent-Execl-Sheet/m-p/1291007#M861415 <HTML><HEAD></HEAD><BODY><P>Hi Miguel ,</P><P></P><P>Can you clarify what you said please ? or any example ?</P><P></P><P>Thanks a lot</P></BODY></HTML> Mon, 09 Jan 2017 09:17:31 GMT https://community.qlik.com/t5/QlikView/Read-From-Diffrent-Execl-Sheet/m-p/1291007#M861415 mario-sarkis 2017-01-09T09:17:31Z Re: Read From Diffrent Execl Sheet https://community.qlik.com/t5/QlikView/Read-From-Diffrent-Execl-Sheet/m-p/1291008#M861416 <HTML><HEAD></HEAD><BODY><P>Hi Mario,</P><P></P><P>Your problem, If I´ve understood correctly, it´s that you have two origins with differents values but similar names.</P><P></P><P>Qualify change <SPAN lang="en">automatically</SPAN> names of fields. If you want to know more about it please read this document <A href="https://community.qlik.com/docs/DOC-7963">Do you Qualify?- How to use QUALIFY statement</A>.</P><P></P><P>Regards</P><P></P><P>Miguel del Valle de Gracia</P></BODY></HTML> Mon, 09 Jan 2017 10:39:32 GMT https://community.qlik.com/t5/QlikView/Read-From-Diffrent-Execl-Sheet/m-p/1291008#M861416 migueldelval 2017-01-09T10:39:32Z