topic values equal to previous period in QlikView https://community.qlik.com/t5/QlikView/values-equal-to-previous-period/m-p/532999#M199119 <HTML><HEAD></HEAD><BODY><P>the inventory data is full of holes, in order to fill in those holes, i have to say if len(onhand)=0, onhand=onhand of previous day for this item at this store. how do i put that in the script?</P><P></P><P>Thanks</P></BODY></HTML> Tue, 02 Jul 2013 19:42:47 GMT yelin_nyu 2013-07-02T19:42:47Z values equal to previous period https://community.qlik.com/t5/QlikView/values-equal-to-previous-period/m-p/532999#M199119 <HTML><HEAD></HEAD><BODY><P>the inventory data is full of holes, in order to fill in those holes, i have to say if len(onhand)=0, onhand=onhand of previous day for this item at this store. how do i put that in the script?</P><P></P><P>Thanks</P></BODY></HTML> Tue, 02 Jul 2013 19:42:47 GMT https://community.qlik.com/t5/QlikView/values-equal-to-previous-period/m-p/532999#M199119 yelin_nyu 2013-07-02T19:42:47Z Re: values equal to previous period https://community.qlik.com/t5/QlikView/values-equal-to-previous-period/m-p/533000#M199120 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Try like this</P><P></P><P>Load *, if(Len(Onhand)=0, previous(Onhand), Onhand) as onHand</P><P>from datasource order by primaryfieldname, datefield asc;</P><P></P><P>Hope it helps</P></BODY></HTML> Tue, 02 Jul 2013 19:49:05 GMT https://community.qlik.com/t5/QlikView/values-equal-to-previous-period/m-p/533000#M199120 MayilVahanan 2013-07-02T19:49:05Z