topic Getting the calculated value into the input field in QlikView https://community.qlik.com/t5/QlikView/Getting-the-calculated-value-into-the-input-field/m-p/106013#M16648 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am brainstorming here, and any help would be great!</P><P></P><P>I need to create an app that will calculate the provisional value of items, and then allow this provisional value to be saved to be referenced the next month.&nbsp; The caviot is that the cost controler needs to be able to replace some calculated values if he deems them un-necessary, etc.&nbsp; </P><P></P><P>So here is what I am thinking the steps could be :</P><P>Step 1 : Table 1 : calculate the provisional value by item, (this is based on multiple variables and dates related to the item) </P><P>Step 2 : The cost controler user can choose to keep the calculated value, or replace it (with an input field). </P><P>Step 3 : When the cost controler is finished with their check, they can click a button which will trigger a macro that saves the table. (to an xml, qvd, etc) </P><P>Step 4 : In another tab we can compare the saved values (and maybe the calculated values also) for this month, to the saved values for the previous month.&nbsp; We will also have charts that show the saved provisional values by item type, etc for the selected month.&nbsp; </P><P></P><P>I'm having trouble implementing these steps.&nbsp; Here are some questions that I need some help with: </P><P>1./ Can my inputfield work in a graphic table (pivot or straight) ?</P><P>2./ Or is it possible to copy a calculated field from Table1 (pivot or straight) to Table2 (plain table with my input field) ? </P><P></P><P>Any ideas for a different way of going about this is also greatly accepted!&nbsp; </P><P>Thanks</P></BODY></HTML> Tue, 25 Sep 2018 09:54:15 GMT leenlart 2018-09-25T09:54:15Z Getting the calculated value into the input field https://community.qlik.com/t5/QlikView/Getting-the-calculated-value-into-the-input-field/m-p/106013#M16648 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am brainstorming here, and any help would be great!</P><P></P><P>I need to create an app that will calculate the provisional value of items, and then allow this provisional value to be saved to be referenced the next month.&nbsp; The caviot is that the cost controler needs to be able to replace some calculated values if he deems them un-necessary, etc.&nbsp; </P><P></P><P>So here is what I am thinking the steps could be :</P><P>Step 1 : Table 1 : calculate the provisional value by item, (this is based on multiple variables and dates related to the item) </P><P>Step 2 : The cost controler user can choose to keep the calculated value, or replace it (with an input field). </P><P>Step 3 : When the cost controler is finished with their check, they can click a button which will trigger a macro that saves the table. (to an xml, qvd, etc) </P><P>Step 4 : In another tab we can compare the saved values (and maybe the calculated values also) for this month, to the saved values for the previous month.&nbsp; We will also have charts that show the saved provisional values by item type, etc for the selected month.&nbsp; </P><P></P><P>I'm having trouble implementing these steps.&nbsp; Here are some questions that I need some help with: </P><P>1./ Can my inputfield work in a graphic table (pivot or straight) ?</P><P>2./ Or is it possible to copy a calculated field from Table1 (pivot or straight) to Table2 (plain table with my input field) ? </P><P></P><P>Any ideas for a different way of going about this is also greatly accepted!&nbsp; </P><P>Thanks</P></BODY></HTML> Tue, 25 Sep 2018 09:54:15 GMT https://community.qlik.com/t5/QlikView/Getting-the-calculated-value-into-the-input-field/m-p/106013#M16648 leenlart 2018-09-25T09:54:15Z Re: Getting the calculated value into the input field https://community.qlik.com/t5/QlikView/Getting-the-calculated-value-into-the-input-field/m-p/106014#M16649 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I think that an input field isn't a great idea in this case.</P><P>You could calculate the previsional value by item and export it in excel with a store command.</P><P>Then you may keep the calculate value or replace it..in excel</P><P>Qlik isn't a well data-entry tool..</P></BODY></HTML> Tue, 25 Sep 2018 13:55:59 GMT https://community.qlik.com/t5/QlikView/Getting-the-calculated-value-into-the-input-field/m-p/106014#M16649 captain89 2018-09-25T13:55:59Z