topic Re: Help on Assigining InputFiled value to forward records in QlikView https://community.qlik.com/t5/QlikView/Help-on-Assigining-InputFiled-value-to-forward-records/m-p/836997#M531137 <HTML><HEAD></HEAD><BODY><P>re posting , appreciate any one advices on this</P></BODY></HTML> Wed, 17 Jun 2015 21:16:54 GMT Anonymous 2015-06-17T21:16:54Z Help on Assigining InputFiled value to forward records https://community.qlik.com/t5/QlikView/Help-on-Assigining-InputFiled-value-to-forward-records/m-p/836995#M531135 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I assigning new Price thorugh InputField and this value has to assigned for forward Period Unless Untill new value assigned then take that new price to take it forward.</P><P></P><P>Like Below assigned 800$ start of 201910 and it is valid up to 202003 See in NewWAC Column and in 202003 entered new price 780 and it should be 780$ starting from 202003 instead of acumulated price from previous value.</P><P></P><P>Can some body advice me on this aggregation.</P><P></P><P>expression:</P><P></P><P>If(WacPrice,WacPrice,</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sum(aggr(rangesum(above(TOTAL inputsum(WacPrice),0,RowNo())),NDC11,Period))</P><P>) </P><P></P><P></P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/89701_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P></BODY></HTML> Wed, 17 Jun 2015 06:08:26 GMT https://community.qlik.com/t5/QlikView/Help-on-Assigining-InputFiled-value-to-forward-records/m-p/836995#M531135 Anonymous 2015-06-17T06:08:26Z Re: Help on Assigining InputFiled value to forward records https://community.qlik.com/t5/QlikView/Help-on-Assigining-InputFiled-value-to-forward-records/m-p/836996#M531136 <HTML><HEAD></HEAD><BODY><P>Hi Can any one help on this logic?</P></BODY></HTML> Wed, 17 Jun 2015 14:25:18 GMT https://community.qlik.com/t5/QlikView/Help-on-Assigining-InputFiled-value-to-forward-records/m-p/836996#M531136 Anonymous 2015-06-17T14:25:18Z Re: Help on Assigining InputFiled value to forward records https://community.qlik.com/t5/QlikView/Help-on-Assigining-InputFiled-value-to-forward-records/m-p/836997#M531137 <HTML><HEAD></HEAD><BODY><P>re posting , appreciate any one advices on this</P></BODY></HTML> Wed, 17 Jun 2015 21:16:54 GMT https://community.qlik.com/t5/QlikView/Help-on-Assigining-InputFiled-value-to-forward-records/m-p/836997#M531137 Anonymous 2015-06-17T21:16:54Z