topic regenerate previous value in QlikView

topic regenerate previous value in QlikView https://community.qlik.com/t5/QlikView/regenerate-previous-value/m-p/48221#M770618 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to fill in previous date's data if the ID and Security doesn't exist for next date.</P><P>Any help on this?</P><P></P><P>Date, ID , Security, Amount</P><P>1/01/2018, 1A, AB1, 100</P><P>1/01/2018, 2B, AB2, 200</P><P>2/01/2018, 1A, AB1, 200</P><P></P><P>I want to regenerate the ID(2B)  and Security(AB2)  with the amount.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT Anonymous 2020-11-25T16:16:04Z regenerate previous value https://community.qlik.com/t5/QlikView/regenerate-previous-value/m-p/48221#M770618 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I want to fill in previous date's data if the ID and Security doesn't exist for next date.</P><P>Any help on this?</P><P></P><P>Date, ID , Security, Amount</P><P>1/01/2018, 1A, AB1, 100</P><P>1/01/2018, 2B, AB2, 200</P><P>2/01/2018, 1A, AB1, 200</P><P></P><P>I want to regenerate the ID(2B)  and Security(AB2)  with the amount.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/regenerate-previous-value/m-p/48221#M770618 Anonymous 2020-11-25T16:16:04Z