topic Adding Excel Data without Losing Previous Data Load in QlikView https://community.qlik.com/t5/QlikView/Adding-Excel-Data-without-Losing-Previous-Data-Load/m-p/1338525#M615445 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>I've been working on designing my first Qlikview dashboard with data that was loaded into the document by the IT department at the company I work for. I don't have access to the database from which they loaded the data I'm working with.</P><P></P><P>I'd like to add a table to the existing data which joins on "Fiscal_Period" in order to add the field "Working_Day" which will allow me to know the number of work days for a given fiscal period. </P><P></P><P>Is there a way to add this table without clicking "reload" and losing all of the data I do not have access to?</P><P></P><P>Thanks an advance for any help! </P></BODY></HTML> Wed, 19 Jul 2017 18:14:27 GMT 2017-07-19T18:14:27Z Adding Excel Data without Losing Previous Data Load https://community.qlik.com/t5/QlikView/Adding-Excel-Data-without-Losing-Previous-Data-Load/m-p/1338525#M615445 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>I've been working on designing my first Qlikview dashboard with data that was loaded into the document by the IT department at the company I work for. I don't have access to the database from which they loaded the data I'm working with.</P><P></P><P>I'd like to add a table to the existing data which joins on "Fiscal_Period" in order to add the field "Working_Day" which will allow me to know the number of work days for a given fiscal period. </P><P></P><P>Is there a way to add this table without clicking "reload" and losing all of the data I do not have access to?</P><P></P><P>Thanks an advance for any help! </P></BODY></HTML> Wed, 19 Jul 2017 18:14:27 GMT https://community.qlik.com/t5/QlikView/Adding-Excel-Data-without-Losing-Previous-Data-Load/m-p/1338525#M615445 2017-07-19T18:14:27Z Re: Adding Excel Data without Losing Previous Data Load https://community.qlik.com/t5/QlikView/Adding-Excel-Data-without-Losing-Previous-Data-Load/m-p/1338526#M615446 <HTML><HEAD></HEAD><BODY><P>You could either change script to do a Partial Reload.</P><P><A href="https://community.qlik.com/thread/48344">What is meant by partial reload? What is its use? Please explain!</A></P><P></P><P>OR</P><P></P><P>You could create a blank application that pulls in the original data in the original QVW through a binary load.</P><P><A href="https://community.qlikview.com/thread/68826" title="https://community.qlikview.com/thread/68826">Binary Load | Qlik Community</A></P></BODY></HTML> Wed, 19 Jul 2017 18:51:00 GMT https://community.qlik.com/t5/QlikView/Adding-Excel-Data-without-Losing-Previous-Data-Load/m-p/1338526#M615446 Anonymous 2017-07-19T18:51:00Z Re: Adding Excel Data without Losing Previous Data Load https://community.qlik.com/t5/QlikView/Adding-Excel-Data-without-Losing-Previous-Data-Load/m-p/1338527#M615447 <HTML><HEAD></HEAD><BODY><P>Thanks for your help! </P><P></P><P>Couldn't get the binary solution to work, but was able to figure out the partial reload. </P></BODY></HTML> Wed, 19 Jul 2017 19:46:15 GMT https://community.qlik.com/t5/QlikView/Adding-Excel-Data-without-Losing-Previous-Data-Load/m-p/1338527#M615447 2017-07-19T19:46:15Z Re: Adding Excel Data without Losing Previous Data Load https://community.qlik.com/t5/QlikView/Adding-Excel-Data-without-Losing-Previous-Data-Load/m-p/1338528#M615448 <HTML><HEAD></HEAD><BODY><P>Glad you figured out something!</P><P>Please close the thread if you are all good now.</P><P></P><P><A href="https://community.qlik.com/docs/DOC-14806">Qlik Community Tip: Marking Replies as Correct or Helpful</A></P></BODY></HTML> Wed, 19 Jul 2017 20:59:28 GMT https://community.qlik.com/t5/QlikView/Adding-Excel-Data-without-Losing-Previous-Data-Load/m-p/1338528#M615448 Anonymous 2017-07-19T20:59:28Z