topic I want to calculate down time in QlikView

I want to calculate down time

Paknanarn23 — Fri, 15 Nov 2024 21:49:51 GMT

I'm having a problem with the Down Time calculation, which is causing too many calculations.

Now I use this formula to calculate Downtime which is the formula used to calculate down time for every report.

But instead, there is a problem that the Start time and Finish time are skipped, causing too much Down time. What should I do?

This is the expression used to find Downtime.

Re: I want to calculate down time

Vegar — Fri, 10 Feb 2023 07:22:58 GMT

It looks like you are calculating downtime by subtracting the start time from the end time.

This will work as long you're in the same date, but intervals that ends after midnight will give you issues.

You can solve this by using the start and end timestamps instead of time if you have them available . If not then you could make an assumption that all end times that are less than start time are timea the next day. Then you could do something like this

=If (FinishMachine < StartMachine,

(FinishMachine+1) - StartMachine,

FinishMachine - StartMachine)

The +1 adds a day (24 hours) to your time making the subtraction correct.

Re: I want to calculate down time

Paknanarn23 — Fri, 10 Feb 2023 07:38:27 GMT

What you gave it doesn't solve my problem. Because I can't even know the finish time. when will it finish

Re: I want to calculate down time

Vegar — Fri, 10 Feb 2023 16:31:29 GMT

I'm sorry about that. I interpreted your upper left red square marking in the table image as two values that you had access to (StartMachine and FinishMachine).

Re: I want to calculate down time

Paknanarn23 — Sat, 11 Feb 2023 02:00:46 GMT

It was time for a downtime error. because the time it started and finished that skips the day causing the downtime it's too much