Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to Cary forward previous month and day wise data

i write this expression for month wise data . i need day wise data

Ex:- i have "Jan to Dec" Data so if i select Dec 15th i need  Cary forward form jan

=if(GetSelectedCount(Call_Month)=0 and GetSelectedCount(Call_Date)=0,
  Num((Count({<Status={'Finished'},Process={'Change'}>}TicketID)/Count({<Process={'Change'}>}TicketID))*100,'##.##')&'%',
  if(GetSelectedCount(Call_Month)> 0,  
  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,'##.##')&'%',
  if(GetSelectedCount(Call_Date)>0,
  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,'##.##')&'%'
)))
1 Reply
kiranmanoharrode
Creator III
Creator III

Dear Irshadali,

Please post sample data for better understanding of requirement.

Regards,

KIran