topic InputField and Inputsum(): round the value, distribute proportionally and knowing which value has been modified in QlikView https://community.qlik.com/t5/QlikView/InputField-and-Inputsum-round-the-value-distribute/m-p/1238669#M393672 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I have a couple of questions for you today.</P><P></P><P>1) I'm looking for a way to round the value when using the inputsum() function.</P><P>My problem is that I need to use the inputsum on a product hierarchy, starting from a product group and then splitting the input value on the underlying products.<BR />I've seen that this works, but the value is not round (which is, <SPAN style="font-size: 13.3333px;">talking of volumes</SPAN>, a very big problem).</P><P>Is there a way to make the inputsum split the value rounding it?</P><P><STRONG>Note</STRONG>: using the "integer" option on the Number menu of the table is not what I'm looking for!</P><P></P><P>2) Similar to the previous question, is there a way to tell the inputsum() function to split the values on the underlying products proportionally to another field (which contains, i.e., a %)?</P><P></P><P>3) Last one: is there a way to know which value of an InputField has been modified from the user?</P><P></P><P></P><P>Thanks in advance</P></BODY></HTML> Thu, 26 Jan 2017 07:44:37 GMT rzenere_avvale 2017-01-26T07:44:37Z InputField and Inputsum(): round the value, distribute proportionally and knowing which value has been modified https://community.qlik.com/t5/QlikView/InputField-and-Inputsum-round-the-value-distribute/m-p/1238669#M393672 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I have a couple of questions for you today.</P><P></P><P>1) I'm looking for a way to round the value when using the inputsum() function.</P><P>My problem is that I need to use the inputsum on a product hierarchy, starting from a product group and then splitting the input value on the underlying products.<BR />I've seen that this works, but the value is not round (which is, <SPAN style="font-size: 13.3333px;">talking of volumes</SPAN>, a very big problem).</P><P>Is there a way to make the inputsum split the value rounding it?</P><P><STRONG>Note</STRONG>: using the "integer" option on the Number menu of the table is not what I'm looking for!</P><P></P><P>2) Similar to the previous question, is there a way to tell the inputsum() function to split the values on the underlying products proportionally to another field (which contains, i.e., a %)?</P><P></P><P>3) Last one: is there a way to know which value of an InputField has been modified from the user?</P><P></P><P></P><P>Thanks in advance</P></BODY></HTML> Thu, 26 Jan 2017 07:44:37 GMT https://community.qlik.com/t5/QlikView/InputField-and-Inputsum-round-the-value-distribute/m-p/1238669#M393672 rzenere_avvale 2017-01-26T07:44:37Z