Hi together.
I’m new to Qlik.
Try to figure out how to set a case, cause with this formula i get my KPI but this includes weekend also. This KPI should show me the availability of the machines inside our production hall.
And it's needed without weekend. My available range for data, is a year with an timestamp, this includes date and time.
(left(interval(Max(Timestamp)-Min(Timestamp)),len(interval(Max(Timestamp)-Min(Timestamp)))-6)*3600 + right(left(interval(Max(Timestamp)-Min(Timestamp)),len(interval(Max(Timestamp)-Min(Timestamp)))-3),2)*60 + right(interval(Max(Timestamp)-Min(Timestamp)),2)) / (86400 * (Max(Datum)-Min(Datum) + 1))
can anyone help me with this issue?
thx.
