Need help on qlikview

Fri, 22 May 2015 05:20:51 GMT

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

topic Need help on qlikview in QlikView

Need help on qlikview