topic Re: Change data and then save into excel in QlikView https://community.qlik.com/t5/QlikView/Change-data-and-then-save-into-excel/m-p/397484#M695356 <HTML><HEAD></HEAD><BODY><P>Hi Alan,</P><P></P><P>Can i change the data in table box?</P><P></P><P>Daniel</P></BODY></HTML> Wed, 22 May 2013 19:11:52 GMT dradoikov 2013-05-22T19:11:52Z Change data and then save into excel https://community.qlik.com/t5/QlikView/Change-data-and-then-save-into-excel/m-p/397480#M695352 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I need help for this problem.</P><P></P><P>I want change data in QlikView UI and then save into Excel file.</P><P></P><P>Thanks,</P><P></P><P>Daniel</P></BODY></HTML> Wed, 22 May 2013 17:54:54 GMT https://community.qlik.com/t5/QlikView/Change-data-and-then-save-into-excel/m-p/397480#M695352 dradoikov 2013-05-22T17:54:54Z Re: Change data and then save into excel https://community.qlik.com/t5/QlikView/Change-data-and-then-save-into-excel/m-p/397481#M695353 <HTML><HEAD></HEAD><BODY><P>You mean export data from the script or from one graph ?</P><P></P><P>From the script you can use the STORE instruction after your table creation :</P><P></P><UL><LI>STORE mytable into myfile.txt (txt); // No excel format available.</LI></UL><P class="Code"></P><P class="Code">From one graph</P><P class="Code"></P><UL><LI>Right click on your graph, chose "export" then a box offer you the possibility to save under Excel format.</LI></UL></BODY></HTML> Wed, 22 May 2013 18:10:45 GMT https://community.qlik.com/t5/QlikView/Change-data-and-then-save-into-excel/m-p/397481#M695353 vivientexier 2013-05-22T18:10:45Z Re: Change data and then save into excel https://community.qlik.com/t5/QlikView/Change-data-and-then-save-into-excel/m-p/397482#M695354 <HTML><HEAD></HEAD><BODY><P>Hi Vivien,</P><P></P><P>Thanks for quik answer.</P><P></P><P>This is the case.</P><P></P><P><SPAN class="hps">in</SPAN> QlikView <SPAN class="hps">is</SPAN> <SPAN class="hps">imported</SPAN> Excel <SPAN class="hps">file.</SPAN></P><P></P><P><SPAN class="hps">In</SPAN> <SPAN class="hps">Excel</SPAN> <SPAN class="hps">there</SPAN> one <SPAN class="hps">column</SPAN> <SPAN class="hps">that I want to</SPAN> <SPAN class="hps">change</SPAN> <SPAN class="hps">in</SPAN> <SPAN class="hps">QlikView </SPAN><SPAN class="hps">through the interface.</SPAN> <SPAN class="hps">After the change</SPAN> <SPAN class="hps">of the information</SPAN> <SPAN class="hps">in</SPAN> <SPAN class="hps">this column</SPAN> <SPAN class="hps">changes need to</SPAN> <SPAN class="hps">be saved</SPAN> <SPAN class="hps">again</SPAN> Excel <SPAN class="hps">file.</SPAN></P><P></P><P><SPAN class="hps">Thanks in advance,</SPAN></P><P><SPAN class="hps">Daniel</SPAN></P></BODY></HTML> Wed, 22 May 2013 19:00:17 GMT https://community.qlik.com/t5/QlikView/Change-data-and-then-save-into-excel/m-p/397482#M695354 dradoikov 2013-05-22T19:00:17Z Re: Change data and then save into excel https://community.qlik.com/t5/QlikView/Change-data-and-then-save-into-excel/m-p/397483#M695355 <HTML><HEAD></HEAD><BODY><P>You can take the Excel file into Qlikview</P><P></P><P>Create a Table box will (Select all Columns) after you have made the Changes and then Export the Table Box Data to Excel and Save the Excel file</P><P></P><P><IMG __jive_id="41563" class="jive-image" alt="Table_Box.png" src="https://community.qlik.com/legacyfs/online/41563_Table_Box.png" /></P></BODY></HTML> Wed, 22 May 2013 19:07:47 GMT https://community.qlik.com/t5/QlikView/Change-data-and-then-save-into-excel/m-p/397483#M695355 rustyfishbones 2013-05-22T19:07:47Z Re: Change data and then save into excel https://community.qlik.com/t5/QlikView/Change-data-and-then-save-into-excel/m-p/397484#M695356 <HTML><HEAD></HEAD><BODY><P>Hi Alan,</P><P></P><P>Can i change the data in table box?</P><P></P><P>Daniel</P></BODY></HTML> Wed, 22 May 2013 19:11:52 GMT https://community.qlik.com/t5/QlikView/Change-data-and-then-save-into-excel/m-p/397484#M695356 dradoikov 2013-05-22T19:11:52Z Re: Change data and then save into excel https://community.qlik.com/t5/QlikView/Change-data-and-then-save-into-excel/m-p/397485#M695357 <HTML><HEAD></HEAD><BODY><P>Only if you defined the field as an Input Field in the load script with the Inputfield statement. See the help file for details. </P></BODY></HTML> Wed, 22 May 2013 19:20:19 GMT https://community.qlik.com/t5/QlikView/Change-data-and-then-save-into-excel/m-p/397485#M695357 Gysbert_Wassenaar 2013-05-22T19:20:19Z Re: Change data and then save into excel https://community.qlik.com/t5/QlikView/Change-data-and-then-save-into-excel/m-p/397486#M695358 <HTML><HEAD></HEAD><BODY><P>Listen to Gysbert, he is far more knowledgeable about these things, so I would trust what he is saying</P><P></P><P>You could make changes in the Script like adding, Month, Year, etc</P><P></P><P>And then add those new fields to the Table Box and then Export</P></BODY></HTML> Wed, 22 May 2013 19:27:09 GMT https://community.qlik.com/t5/QlikView/Change-data-and-then-save-into-excel/m-p/397486#M695358 rustyfishbones 2013-05-22T19:27:09Z Re: Change data and then save into excel https://community.qlik.com/t5/QlikView/Change-data-and-then-save-into-excel/m-p/397487#M695359 <HTML><HEAD></HEAD><BODY><P><SPAN class="hps">Runs great</SPAN>!</P><P></P><P><SPAN class="hps">Thank you very much <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></SPAN></P></BODY></HTML> Wed, 22 May 2013 20:54:01 GMT https://community.qlik.com/t5/QlikView/Change-data-and-then-save-into-excel/m-p/397487#M695359 dradoikov 2013-05-22T20:54:01Z