Server Availability expression

[#1]

Hi,

I'm trying to get show the availability for some servers. The problem I'm having is showing when a server has 100% availability, because there are no records of downtime.

I've tried this (QlikFit: Set analysis that ignores all selections except a few) solution but I couldn't get it to work. Anyone got a suggestion how to solve this? It might be a easy fix but I'm pretty stuck and been staring at this problem for far too long.

See the attached file for more information.

The original post were I got some help fixing my tables:

https://community.qlik.com/message/970751?et=watches.email.thread#970751

[#2 · Accepted solution]

I've managed to solve it. If anyone got any better solution I would love to hear about it!