topic Inputsum question in QlikView https://community.qlik.com/t5/QlikView/Inputsum-question/m-p/418580#M155733 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have created a demo application (see attached) that uses InputSum() to allow the user to make changes to data that was loaded a QlikView table - they can then use the "Export to Excel" feature to write the amended data to the source spreadsheet.</P><P></P><P>Although this method of offering the user a means of updating the values is a little crude it works, partly. You see, the figures that are being displayed are Sales/Forecast figures - in other words for the months that have elapsed (i.e. January through to August) the table shows "Sales" and for the remainder "Forecasted Sales" - the idea is to allow them to edit ONLY those months that have not yet elapsed. </P><P></P><P>Have&nbsp; a look at the attached example and let me know if you can think of a better way to handle this requirement.</P><P></P><P>Thanx</P><P>Alexis</P></BODY></HTML> Tue, 18 Sep 2012 17:29:15 GMT alexis 2012-09-18T17:29:15Z Inputsum question https://community.qlik.com/t5/QlikView/Inputsum-question/m-p/418580#M155733 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I have created a demo application (see attached) that uses InputSum() to allow the user to make changes to data that was loaded a QlikView table - they can then use the "Export to Excel" feature to write the amended data to the source spreadsheet.</P><P></P><P>Although this method of offering the user a means of updating the values is a little crude it works, partly. You see, the figures that are being displayed are Sales/Forecast figures - in other words for the months that have elapsed (i.e. January through to August) the table shows "Sales" and for the remainder "Forecasted Sales" - the idea is to allow them to edit ONLY those months that have not yet elapsed. </P><P></P><P>Have&nbsp; a look at the attached example and let me know if you can think of a better way to handle this requirement.</P><P></P><P>Thanx</P><P>Alexis</P></BODY></HTML> Tue, 18 Sep 2012 17:29:15 GMT https://community.qlik.com/t5/QlikView/Inputsum-question/m-p/418580#M155733 alexis 2012-09-18T17:29:15Z