topic Re: How to Cary forward previous month and day wise data in QlikView

topic Re: How to Cary forward previous month and day wise data in QlikView https://community.qlik.com/t5/QlikView/How-to-Cary-forward-previous-month-and-day-wise-data/m-p/763311#M1038812 <HTML><HEAD></HEAD><BODY><P>Dear Irshadali,</P><P></P><P>Please post sample data for better understanding of requirement.</P><P></P><P></P><P>Regards,</P><P>KIran</P></BODY></HTML> Fri, 09 Jan 2015 14:19:37 GMT kiranmanoharrode 2015-01-09T14:19:37Z How to Cary forward previous month and day wise data https://community.qlik.com/t5/QlikView/How-to-Cary-forward-previous-month-and-day-wise-data/m-p/763310#M1038811 <HTML><HEAD></HEAD><BODY><H5><SPAN style="color: #000000;">i write this expression for month wise data . i need day wise data </SPAN></H5><H5><SPAN style="color: #000000;"><BR /></SPAN></H5><H5><SPAN style="color: #000000;">Ex:- i have "Jan to Dec" Data so if i select Dec 15th i need  Cary forward form jan <BR /></SPAN></H5><H5><SPAN style="color: #000000;"><BR /></SPAN></H5><H5><SPAN style="color: #000000;">=if(GetSelectedCount(Call_Month)=0 and GetSelectedCount(Call_Date)=0,</SPAN></H5><H5><SPAN style="color: #000000;">  Num((Count({<Status={'Finished'},Process={'Change'}>}TicketID)/Count({<Process={'Change'}>}TicketID))*100,'##.##')&'%',</SPAN></H5><H5><SPAN style="color: #000000;">  if(GetSelectedCount(Call_Month)> 0,   </SPAN></H5><H5><SPAN style="color: #000000;">  Num((Count({<Status={'Finished'},Process={'Change'}>}TicketID)/(Count({<Process={'Change'}>}TicketID)+Count({<Process={'Change'},Status={'*'}-{'Finished','Rejected'},Call_Month={"$(=Month(AddMonths(max(Logged),-1)))"}>}TicketID)))*100,'##.##')&'%',</SPAN></H5><H5><SPAN style="color: #000000;">  if(GetSelectedCount(Call_Date)>0,</SPAN></H5><H5><SPAN style="color: #000000;">  Num((Count({<Status={'Finished'},Process={'Change'}>}TicketID)/(Count({<Process={'Change'}>}TicketID)+Count({<Process={'Change'},Status={'*'}-{'Finished','Rejected'},Call_Date={"$(=Date(Call_Date-1))"}>}TicketID)))*100,'##.##')&'%'</SPAN></H5><H5><SPAN style="color: #000000;"> )))</SPAN></H5></BODY></HTML> Fri, 09 Jan 2015 14:15:30 GMT https://community.qlik.com/t5/QlikView/How-to-Cary-forward-previous-month-and-day-wise-data/m-p/763310#M1038811 2015-01-09T14:15:30Z Re: How to Cary forward previous month and day wise data https://community.qlik.com/t5/QlikView/How-to-Cary-forward-previous-month-and-day-wise-data/m-p/763311#M1038812 <HTML><HEAD></HEAD><BODY><P>Dear Irshadali,</P><P></P><P>Please post sample data for better understanding of requirement.</P><P></P><P></P><P>Regards,</P><P>KIran</P></BODY></HTML> Fri, 09 Jan 2015 14:19:37 GMT https://community.qlik.com/t5/QlikView/How-to-Cary-forward-previous-month-and-day-wise-data/m-p/763311#M1038812 kiranmanoharrode 2015-01-09T14:19:37Z