topic Looking for help in QlikView https://community.qlik.com/t5/QlikView/Looking-for-help/m-p/179231#M46163 <HTML><HEAD></HEAD><BODY><P>Hey folks. I don't know how to search the forum for this, so I'll just post my problem and hope for some help.</P><P>My table houses many different costs and dates associated with those costs. Unfortunately, our data isn't great, and there's nulls where there should be expiration dates. So for example I have the following situation:</P><P>Record 1<BR />NDC = 11111<BR />Cost = $1.45<BR />Effective Date = 1/1/2008<BR />Expiration Date = null</P><P>Record2<BR />NDC = 11111<BR />Cost = $1.56<BR />Effective Date = 1/1/2009<BR />Expiration Date = null<BR /><BR />What I want to do is get the expiration date on record 1 to be the record2 effective date minus 1 day. This isn't the case all of the time, but we are experiencing this for about 1/10 of the time.</P><P>Hoping somebody can help.</P><P>Rob</P></BODY></HTML> Tue, 08 Sep 2009 22:38:23 GMT 2009-09-08T22:38:23Z Looking for help https://community.qlik.com/t5/QlikView/Looking-for-help/m-p/179231#M46163 <HTML><HEAD></HEAD><BODY><P>Hey folks. I don't know how to search the forum for this, so I'll just post my problem and hope for some help.</P><P>My table houses many different costs and dates associated with those costs. Unfortunately, our data isn't great, and there's nulls where there should be expiration dates. So for example I have the following situation:</P><P>Record 1<BR />NDC = 11111<BR />Cost = $1.45<BR />Effective Date = 1/1/2008<BR />Expiration Date = null</P><P>Record2<BR />NDC = 11111<BR />Cost = $1.56<BR />Effective Date = 1/1/2009<BR />Expiration Date = null<BR /><BR />What I want to do is get the expiration date on record 1 to be the record2 effective date minus 1 day. This isn't the case all of the time, but we are experiencing this for about 1/10 of the time.</P><P>Hoping somebody can help.</P><P>Rob</P></BODY></HTML> Tue, 08 Sep 2009 22:38:23 GMT https://community.qlik.com/t5/QlikView/Looking-for-help/m-p/179231#M46163 2009-09-08T22:38:23Z Looking for help https://community.qlik.com/t5/QlikView/Looking-for-help/m-p/179232#M46164 <HTML><HEAD></HEAD><BODY><P>This can be achieved using peek() function.</P><P>I have tried out a sample app, which replaces 0 with the value from subsequent row.</P><P>Just have a look at the script. Hope it may help</P></BODY></HTML> Tue, 08 Sep 2009 23:16:47 GMT https://community.qlik.com/t5/QlikView/Looking-for-help/m-p/179232#M46164 2009-09-08T23:16:47Z