Hi I am new qlik and need your help here
I have a requirement to get the failure duration on all the systems which are present in the below table which are mapped to unique key
SystemID .So far I have created a master calendar based on start _time column as that is the time the 1st system was added . Now I have a requirement . have to calculate the overall failure % of the each system .
So below are my requirement
1. If no Date is selected in the master calendar so I should be able to get the overall failure % of all the system starting from minimum value of start_time to till current time . this I need to show as overall in text box as well as for each system id in straight table
2. If only Year is selected in the master calendar so I should be able to get the overall failure % of all the system starting from minimum value of start_time to till current time for selected year . this I need to show as overall in text box as well as for each system id in straight table
3. If month is selected in the master calendar so I should be able to get the overall failure % of all the system starting from 1st date of month to till last date of selected month and this should display the failure % of the failure happened in the selected month as overall in text box as well as for each system id in straight table .
4 . if a date is selected , then the failure % should be calculated based on failure duration for that particular day
Here for all the cases I need to consider "Unplanned" FailureName only for all the calculation.
SystemID,start_time,end_time,duration,failureType,FailureName
____________________________________________________________
192408,3/19/2015 17:29,3/19/2015 17:29,0,0,Initial
192414,3/19/2015 17:29,3/19/2015 17:29,0,0,Initial
192408,3/20/2015 15:15,4/20/2015 21:54,2702342,2,Planned
217382,5/7/2015 21:41,5/7/2015 21:41,0,0,Initial
217382,5/11/2015 17:32,NULL,607225,1,Unplanned
