topic Resetting Initial Date in QlikView https://community.qlik.com/t5/QlikView/Resetting-Initial-Date/m-p/463730#M173185 <HTML><HEAD></HEAD><BODY><P>In order to find Initial Date and Initial Price for any Product, I have, for example:</P><P></P><P>FromDate&nbsp;&nbsp; ToDate&nbsp;&nbsp; ProdID&nbsp;&nbsp; Price</P><P>3/23&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $19.99</P><P>4/6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $17.99</P><P>4/20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5/4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $19.99</P><P>5/18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6/3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $16.99</P><P>6/01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6/15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $15.99&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>Currently, I'm finding Initial Date and Price by:</P><P></P><P>Load</P><P>ProdID,</P><P>Price As InitPrice,</P><P>Date(Min(FromDate)) As InitDate</P><P>From TableName</P><P>Group By ProdID, Price;</P><P></P><P>Now the requirement is, if there's a gap and we do not get data for a Product for an interval (in this case two weeks), Initial Date should be set to when data is sent after the gap.</P><P>In this case, Initial Date should be 5/18 (and not 3/23) since, product (P1) missed data from 5/4 to 5/18.</P><P></P><P>Is there a way to achieve this?</P></BODY></HTML> Wed, 15 May 2013 17:20:38 GMT Anonymous 2013-05-15T17:20:38Z Resetting Initial Date https://community.qlik.com/t5/QlikView/Resetting-Initial-Date/m-p/463730#M173185 <HTML><HEAD></HEAD><BODY><P>In order to find Initial Date and Initial Price for any Product, I have, for example:</P><P></P><P>FromDate&nbsp;&nbsp; ToDate&nbsp;&nbsp; ProdID&nbsp;&nbsp; Price</P><P>3/23&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $19.99</P><P>4/6&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4/20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $17.99</P><P>4/20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5/4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $19.99</P><P>5/18&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6/3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $16.99</P><P>6/01&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6/15&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; P1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $15.99&nbsp;&nbsp;&nbsp;&nbsp; </P><P></P><P>Currently, I'm finding Initial Date and Price by:</P><P></P><P>Load</P><P>ProdID,</P><P>Price As InitPrice,</P><P>Date(Min(FromDate)) As InitDate</P><P>From TableName</P><P>Group By ProdID, Price;</P><P></P><P>Now the requirement is, if there's a gap and we do not get data for a Product for an interval (in this case two weeks), Initial Date should be set to when data is sent after the gap.</P><P>In this case, Initial Date should be 5/18 (and not 3/23) since, product (P1) missed data from 5/4 to 5/18.</P><P></P><P>Is there a way to achieve this?</P></BODY></HTML> Wed, 15 May 2013 17:20:38 GMT https://community.qlik.com/t5/QlikView/Resetting-Initial-Date/m-p/463730#M173185 Anonymous 2013-05-15T17:20:38Z