topic Re: InputSum - Mode in QlikView https://community.qlik.com/t5/QlikView/InputSum-Mode/m-p/1195478#M385699 <HTML><HEAD></HEAD><BODY><P>Hi Solomon, the parameter of inputsum is used when the value of a input field is edited in front-end. </P><P></P><P>In example, if you had a teble with only Dept and Mark2, and you edit the value in Mark2... How will be distributed the value you entered between the different 'Name'?</P><P></P><P>Try it with a pivot table setting Dept and Name as dimensions and inputsum as expression. Collapse the Dept. change the value of the input field and expand again the Name to check the distribution it makes with the different parameters.</P><P></P><P>It can be based on the different values, on number of records for each value, same value for all records...</P></BODY></HTML> Fri, 30 Sep 2016 08:37:20 GMT rubenmarin 2016-09-30T08:37:20Z InputSum - Mode https://community.qlik.com/t5/QlikView/InputSum-Mode/m-p/1195477#M385698 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I tried Inputsum Function, Having 'Mark2' column editable.</P><P>I don't understand the difference that the mode makes.</P><P></P><P>Please any one clarify my doubt.</P><P><IMG alt="1.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/139247_1.png" style="height: 349px; width: 620px;" /></P><P>Thanks in ADVANCE.</P></BODY></HTML> Fri, 30 Sep 2016 08:11:03 GMT https://community.qlik.com/t5/QlikView/InputSum-Mode/m-p/1195477#M385698 soloeeeoff 2016-09-30T08:11:03Z Re: InputSum - Mode https://community.qlik.com/t5/QlikView/InputSum-Mode/m-p/1195478#M385699 <HTML><HEAD></HEAD><BODY><P>Hi Solomon, the parameter of inputsum is used when the value of a input field is edited in front-end. </P><P></P><P>In example, if you had a teble with only Dept and Mark2, and you edit the value in Mark2... How will be distributed the value you entered between the different 'Name'?</P><P></P><P>Try it with a pivot table setting Dept and Name as dimensions and inputsum as expression. Collapse the Dept. change the value of the input field and expand again the Name to check the distribution it makes with the different parameters.</P><P></P><P>It can be based on the different values, on number of records for each value, same value for all records...</P></BODY></HTML> Fri, 30 Sep 2016 08:37:20 GMT https://community.qlik.com/t5/QlikView/InputSum-Mode/m-p/1195478#M385699 rubenmarin 2016-09-30T08:37:20Z