topic Re: Split set of Dates based on the input value in QlikView https://community.qlik.com/t5/QlikView/Split-set-of-Dates-based-on-the-input-value/m-p/404828#M701798 <HTML><HEAD></HEAD><BODY><P>Using Class function we can achieve this.</P><P></P><P>Sample is attached</P></BODY></HTML> Wed, 21 Nov 2012 06:33:39 GMT Anonymous 2012-11-21T06:33:39Z Split set of Dates based on the input value https://community.qlik.com/t5/QlikView/Split-set-of-Dates-based-on-the-input-value/m-p/404826#M701796 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>My scenario is </P><P></P><P>In my table I have two fields Date and Amount.</P><P></P><P>I need to split the set of dates based on the given input.</P><P></P><P>Like,</P><P></P><P>If I gave input as 10, then it should split dates in 10. From 01-09-2012 to 10-09-2012, 11 to 20 and so on and the sum of amount to be calculated for the date frame.</P><P></P><P>For Example,</P><P>Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Amount</P><P>01-09-2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>02-09-2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp; </P><P>03-09-2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>04-09-2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P>05-09-2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp; </P><P>06-09-2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P></P><P>Input value = 3</P><P><STRONG>output:</STRONG></P><P>DateFrame&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Amount</P><P>01-09-2012 - 03-09-2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30 </P><P>04-09-2012 - 06-09-2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 60</P><P></P><P>Thanks in Advance.</P><P></P><P>Regards,</P><P>Leni </P></BODY></HTML> Thu, 13 Sep 2012 11:38:01 GMT https://community.qlik.com/t5/QlikView/Split-set-of-Dates-based-on-the-input-value/m-p/404826#M701796 Anonymous 2012-09-13T11:38:01Z Re: Split set of Dates based on the input value https://community.qlik.com/t5/QlikView/Split-set-of-Dates-based-on-the-input-value/m-p/404827#M701797 <HTML><HEAD></HEAD><BODY><P>Any help??</P></BODY></HTML> Fri, 14 Sep 2012 05:26:13 GMT https://community.qlik.com/t5/QlikView/Split-set-of-Dates-based-on-the-input-value/m-p/404827#M701797 Anonymous 2012-09-14T05:26:13Z Re: Split set of Dates based on the input value https://community.qlik.com/t5/QlikView/Split-set-of-Dates-based-on-the-input-value/m-p/404828#M701798 <HTML><HEAD></HEAD><BODY><P>Using Class function we can achieve this.</P><P></P><P>Sample is attached</P></BODY></HTML> Wed, 21 Nov 2012 06:33:39 GMT https://community.qlik.com/t5/QlikView/Split-set-of-Dates-based-on-the-input-value/m-p/404828#M701798 Anonymous 2012-11-21T06:33:39Z