topic Re: Script like cumuletieve in QlikView https://community.qlik.com/t5/QlikView/Script-like-cumuletieve/m-p/1105804#M915431 <HTML><HEAD></HEAD><BODY><P>Try like</P><P>If (rowno()=1,1-fieldname,(1-peek(XP))*(1-fieldname)) as XP</P></BODY></HTML> Thu, 19 May 2016 16:30:32 GMT settu_periasamy 2016-05-19T16:30:32Z Script like cumuletieve https://community.qlik.com/t5/QlikView/Script-like-cumuletieve/m-p/1105800#M915427 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>Can you please explain how to implement bellow one.</P><P></P><P>XP</P><P>--------</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">1-(1-current record)</SPAN></P><P>1-{(1-prev result)*(1-current record)}</P><P>:</P><P>:</P><P>:</P><P>:</P><P>And so on n th record</P><P></P><P>XP is field name</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Script-like-cumuletieve/m-p/1105800#M915427 2020-11-25T16:16:04Z Re: Script like cumuletieve https://community.qlik.com/t5/QlikView/Script-like-cumuletieve/m-p/1105801#M915428 <HTML><HEAD></HEAD><BODY><P>Here i have the separate field for current , next recods.</P><P></P><P>Sales rate</P><P>-------------------</P><P>1</P><P>2</P><P>3</P><P>4</P><P>6</P><P>8</P><P>:</P><P>:</P><P>:</P><P>And so on n th record</P><P></P><P>Using this need to calculate in qv script.</P><P></P><P></P><P>Thanks.</P></BODY></HTML> Thu, 19 May 2016 16:02:27 GMT https://community.qlik.com/t5/QlikView/Script-like-cumuletieve/m-p/1105801#M915428 2016-05-19T16:02:27Z Re: Script like cumuletieve https://community.qlik.com/t5/QlikView/Script-like-cumuletieve/m-p/1105802#M915429 <HTML><HEAD></HEAD><BODY><P>What is the expected output here?</P></BODY></HTML> Thu, 19 May 2016 16:25:33 GMT https://community.qlik.com/t5/QlikView/Script-like-cumuletieve/m-p/1105802#M915429 sunny_talwar 2016-05-19T16:25:33Z Re: Script like cumuletieve https://community.qlik.com/t5/QlikView/Script-like-cumuletieve/m-p/1105803#M915430 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>Do you have any kind of data that you want to implement this rate? Creating this out of nowhere to me seems dificult. Can you please attach a QVD or a QVW or even specify what for you need this rate?</P><P></P><P>Regards,</P><P>MB</P></BODY></HTML> Thu, 19 May 2016 16:29:16 GMT https://community.qlik.com/t5/QlikView/Script-like-cumuletieve/m-p/1105803#M915430 miguelbraga 2016-05-19T16:29:16Z Re: Script like cumuletieve https://community.qlik.com/t5/QlikView/Script-like-cumuletieve/m-p/1105804#M915431 <HTML><HEAD></HEAD><BODY><P>Try like</P><P>If (rowno()=1,1-fieldname,(1-peek(XP))*(1-fieldname)) as XP</P></BODY></HTML> Thu, 19 May 2016 16:30:32 GMT https://community.qlik.com/t5/QlikView/Script-like-cumuletieve/m-p/1105804#M915431 settu_periasamy 2016-05-19T16:30:32Z