https://community.qlik.com/t5/QlikView/Bifurcation/m-p/505902#M189153 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Did the code solve your issue?</P><P></P><P>Thanks</P><P><BR />Steve</P></BODY></HTML> Fri, 04 Oct 2013 08:37:22 GMT 2013-10-04T08:37:22Z https://community.qlik.com/t5/QlikView/Bifurcation/m-p/505900#M189151 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>There is this scenario wherein user wants to bifurcate data on the monthly basis.</P><P>We have a table with Start_date, End_Date and Amount.Suppose one record is like</P><P>03-10-2012,30-06-2013,16000 respectively.</P><P>Now the requirement is that instead of this one record, the data should be bifurcated month-wise, like:</P><P></P><P>03-10-2012,31-10-2012,2000</P><P>01-11-2012,30-11-2012,2000</P><P>01-12-2012,31-12-2012,2000</P><P>.</P><P>.</P><P>.</P><P>.</P><P>01-06-2013,30,06,2013,2000</P><P></P><P>How can this be attained? Please help</P></BODY></HTML> Thu, 03 Oct 2013 07:40:31 GMT https://community.qlik.com/t5/QlikView/Bifurcation/m-p/505900#M189151 varunjain 2013-10-03T07:40:31Z https://community.qlik.com/t5/QlikView/Bifurcation/m-p/505901#M189152 <HTML><HEAD></HEAD><BODY><P>Hi Varun</P><P></P><P>Please see the attached file.</P><P></P><P>Please note, your example covers 9months (not 8months) so the value per month is 1777.78 (16000/9).</P><P></P><P>Let me know if this is the correct and/or helpful answer.</P><P></P><P><BR />Regards</P><P><BR />Steve</P></BODY></HTML> Thu, 03 Oct 2013 09:05:59 GMT https://community.qlik.com/t5/QlikView/Bifurcation/m-p/505901#M189152 2013-10-03T09:05:59Z https://community.qlik.com/t5/QlikView/Bifurcation/m-p/505902#M189153 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Did the code solve your issue?</P><P></P><P>Thanks</P><P><BR />Steve</P></BODY></HTML> Fri, 04 Oct 2013 08:37:22 GMT https://community.qlik.com/t5/QlikView/Bifurcation/m-p/505902#M189153 2013-10-04T08:37:22Z