topic Date Offset in QlikView https://community.qlik.com/t5/QlikView/Date-Offset/m-p/376618#M140413 <HTML><HEAD></HEAD><BODY><P>I am loading dates from a qvd file and am looking to create a date offset. in other words, if "[Real Date]" is 8/6/2012, i want [Offset Date] to be three days before [Real Date]. i have tried date(only([Real Date])-3) but that will always give me 3 calendar days before (8/3/2012 in my example). i am looking to show only 3 [Real Date]'s ago, to account for weekends and days not othewise loaded as [Real Dates]. a better example might be [Real Date]=7/5/2012. my current expression will give me 7/2/2012, however, due to a weekend and no activity on 7/4, the day i am looking for is 6/29/2012. <SPAN style=": ; color: #0000ff; font-size: 8pt;"></SPAN></P><P></P><P></P></BODY></HTML> Thu, 09 Aug 2012 13:36:39 GMT 2012-08-09T13:36:39Z Date Offset https://community.qlik.com/t5/QlikView/Date-Offset/m-p/376618#M140413 <HTML><HEAD></HEAD><BODY><P>I am loading dates from a qvd file and am looking to create a date offset. in other words, if "[Real Date]" is 8/6/2012, i want [Offset Date] to be three days before [Real Date]. i have tried date(only([Real Date])-3) but that will always give me 3 calendar days before (8/3/2012 in my example). i am looking to show only 3 [Real Date]'s ago, to account for weekends and days not othewise loaded as [Real Dates]. a better example might be [Real Date]=7/5/2012. my current expression will give me 7/2/2012, however, due to a weekend and no activity on 7/4, the day i am looking for is 6/29/2012. <SPAN style=": ; color: #0000ff; font-size: 8pt;"></SPAN></P><P></P><P></P></BODY></HTML> Thu, 09 Aug 2012 13:36:39 GMT https://community.qlik.com/t5/QlikView/Date-Offset/m-p/376618#M140413 2012-08-09T13:36:39Z Re: Date Offset https://community.qlik.com/t5/QlikView/Date-Offset/m-p/376619#M140414 <HTML><HEAD></HEAD><BODY><P>You could use Peek function to achieve that assuming that not real dates are not in your database.</P></BODY></HTML> Thu, 09 Aug 2012 13:40:55 GMT https://community.qlik.com/t5/QlikView/Date-Offset/m-p/376619#M140414 giakoum 2012-08-09T13:40:55Z Re: Date Offset https://community.qlik.com/t5/QlikView/Date-Offset/m-p/376620#M140415 <HTML><HEAD></HEAD><BODY><P>Thank you Ioannis. so would my script look something like </P><P>date(peek([Real Date])-3 as [Offset Date]?</P></BODY></HTML> Thu, 09 Aug 2012 13:52:30 GMT https://community.qlik.com/t5/QlikView/Date-Offset/m-p/376620#M140415 2012-08-09T13:52:30Z Re: Date Offset https://community.qlik.com/t5/QlikView/Date-Offset/m-p/376621#M140416 <HTML><HEAD></HEAD><BODY><P>Peek(<SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">[Real Date]</SPAN>, RowNo()-4) as <SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;"> [Offset Date]</SPAN></P><P></P><P><SPAN style="color: #636363; font-family: Arial; font-size: 12px; background-color: #eef4f9;">Just be careful with the edges, where no value is there 3 rows before.<BR /></SPAN></P></BODY></HTML> Thu, 09 Aug 2012 14:05:26 GMT https://community.qlik.com/t5/QlikView/Date-Offset/m-p/376621#M140416 giakoum 2012-08-09T14:05:26Z Re: Date Offset https://community.qlik.com/t5/QlikView/Date-Offset/m-p/376622#M140417 <HTML><HEAD></HEAD><BODY><P>Great. thank you</P></BODY></HTML> Thu, 09 Aug 2012 14:11:09 GMT https://community.qlik.com/t5/QlikView/Date-Offset/m-p/376622#M140417 2012-08-09T14:11:09Z