QlikView November 2017 Service Release 7 now available

[Anonymous]

Hello everyone,

Okay here is what I have been attempting to do, I have a field named Downtime which measures the time a service went down for - e.g 01:22  (hh:mm) question is how to I convert this metric to an % of service availability per month. 

Appreciate any help offered.

Nev 

[jensmunnichs]

Is your service availability different every month? And if so is it a field in your data model? Or do you know how to calculate your service availability?

Whatever the case, as long as both values are properly formatted, you should just be able to divide downtime by service availability and set number presentation to %.

So for a table with month as a dimension, your expression would be:
Time(Sum(Downtime)) / [Service availability]

Where [Service availability] should be:
- A fixed number if it is the same every month: For example, Time('55:00') for 55 hours/month
- A pick/match combo or lots of nested ifs (not recommended) for variable service availability
- The average of the service availability if it is in a field in your data. This is assuming the service availability is the same for every record in the same month. Note that this does mess up your total

If you need more help please post your application, if possible with sample data.

Also, interesting title 😉