topic Re: Availability by Date in QlikView https://community.qlik.com/t5/QlikView/Availability-by-Date/m-p/644762#M236301 <HTML><HEAD></HEAD><BODY><P>Excellent... I was an inch away ... <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Mon, 09 Jun 2014 14:32:21 GMT MK_QSL 2014-06-09T14:32:21Z Availability by Date https://community.qlik.com/t5/QlikView/Availability-by-Date/m-p/644758#M236297 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12.0pt;">We have projects allocated to each machine and one machine is having more than one projects allocated due to forecast….</SPAN></P><P></P><P><SPAN style="font-size: 12.0pt;">Objective is to find out on which day which Machine is available/free to allocate future project…</SPAN></P><P></P><P><SPAN style="font-size: 12.0pt;">Data : Something like below</SPAN></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="261"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; background: yellow; padding: 0 5.4pt 0 5.4pt;" width="61"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>Machine</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: yellow; padding: 0 5.4pt 0 5.4pt;" width="51"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>Project</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: yellow; padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>StartDate</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: yellow; padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>FinishDate</STRONG></SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="61"><P align="center" style="text-align: center;"><SPAN style="color: black;">M1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="51"><P align="center" style="text-align: center;"><SPAN style="color: black;">P1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;">09/06/2014</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;">10/06/2014</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="61"><P align="center" style="text-align: center;"><SPAN style="color: black;">M1</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="51"><P align="center" style="text-align: center;"><SPAN style="color: black;">P2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;">12/06/2014</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;">12/06/2014</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="61"><P align="center" style="text-align: center;"><SPAN style="color: black;">M2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="51"><P align="center" style="text-align: center;"><SPAN style="color: black;">P3</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;">08/06/2014</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;">11/06/2014</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="61"><P align="center" style="text-align: center;"><SPAN style="color: black;">M2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="51"><P align="center" style="text-align: center;"><SPAN style="color: black;">P4</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;">15/06/2014</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;">16/06/2014</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="61"><P align="center" style="text-align: center;"><SPAN style="color: black;">M2</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="51"><P align="center" style="text-align: center;"><SPAN style="color: black;">P5</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;">20/06/2014</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;">22/06/2014</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="61"><P align="center" style="text-align: center;"><SPAN style="color: black;">M3</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="51"><P align="center" style="text-align: center;"><SPAN style="color: black;">P6</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;">08/06/2014</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;">12/06/2014</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="61"><P align="center" style="text-align: center;"><SPAN style="color: black;">M3</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="51"><P align="center" style="text-align: center;"><SPAN style="color: black;">P7</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;">18/06/2014</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;">22/06/2014</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="61"><P align="center" style="text-align: center;"><SPAN style="color: black;">M3</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="51"><P align="center" style="text-align: center;"><SPAN style="color: black;">P8</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;">24/06/2014</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="75"><P align="center" style="text-align: center;"><SPAN style="color: black;">24/06/2014</SPAN></P></TD></TR></TBODY></TABLE><P></P><P></P><P><SPAN style="font-size: 12.0pt;">Output required:</SPAN></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="183"><TBODY><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; background: yellow; padding: 0 5.4pt 0 5.4pt;" width="99"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>ReportingDate</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: yellow; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>M1</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: yellow; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>M2</STRONG></SPAN></P></TD><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-left: none; background: yellow; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;"><STRONG>M3</STRONG></SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="99"><P align="center" style="text-align: center;"><SPAN style="color: black;">08/06/2014</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">NO</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">NO</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="99"><P align="center" style="text-align: center;"><SPAN style="color: black;">09/06/2014</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">NO</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">NO</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">NO</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="99"><P align="center" style="text-align: center;"><SPAN style="color: black;">10/06/2014</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">NO</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">NO</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">NO</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="99"><P align="center" style="text-align: center;"><SPAN style="color: black;">11/06/2014</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">NO</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">NO</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="99"><P align="center" style="text-align: center;"><SPAN style="color: black;">12/06/2014</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">NO</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">NO</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="99"><P align="center" style="text-align: center;"><SPAN style="color: black;">13/06/2014</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="99"><P align="center" style="text-align: center;"><SPAN style="color: black;">14/06/2014</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="99"><P align="center" style="text-align: center;"><SPAN style="color: black;">15/06/2014</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">NO</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="99"><P align="center" style="text-align: center;"><SPAN style="color: black;">16/06/2014</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">NO</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="99"><P align="center" style="text-align: center;"><SPAN style="color: black;">17/06/2014</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="99"><P align="center" style="text-align: center;"><SPAN style="color: black;">18/06/2014</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">NO</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="99"><P align="center" style="text-align: center;"><SPAN style="color: black;">19/06/2014</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">NO</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="99"><P align="center" style="text-align: center;"><SPAN style="color: black;">20/06/2014</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">NO</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">NO</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="99"><P align="center" style="text-align: center;"><SPAN style="color: black;">21/06/2014</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">NO</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">NO</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="99"><P align="center" style="text-align: center;"><SPAN style="color: black;">22/06/2014</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">NO</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">NO</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="99"><P align="center" style="text-align: center;"><SPAN style="color: black;">23/06/2014</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" width="99"><P align="center" style="text-align: center;"><SPAN style="color: black;">24/06/2014</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">YES</SPAN></P></TD><TD nowrap="nowrap" style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" width="28"><P align="center" style="text-align: center;"><SPAN style="color: black;">NO</SPAN></P></TD></TR></TBODY></TABLE><P></P><P>HERE YES means, machine is available for project on that day and NO means, it's already in use....</P></BODY></HTML> Mon, 09 Jun 2014 13:25:41 GMT https://community.qlik.com/t5/QlikView/Availability-by-Date/m-p/644758#M236297 MK_QSL 2014-06-09T13:25:41Z Re: Availability by Date https://community.qlik.com/t5/QlikView/Availability-by-Date/m-p/644759#M236298 <HTML><HEAD></HEAD><BODY><P>You can intervalmatch reporting date to [StartDate, FinishDate]?</P></BODY></HTML> Mon, 09 Jun 2014 13:29:11 GMT https://community.qlik.com/t5/QlikView/Availability-by-Date/m-p/644759#M236298 2014-06-09T13:29:11Z Re: Availability by Date https://community.qlik.com/t5/QlikView/Availability-by-Date/m-p/644760#M236299 <HTML><HEAD></HEAD><BODY><P>Cant' use as original Database is much more complex....</P></BODY></HTML> Mon, 09 Jun 2014 13:41:29 GMT https://community.qlik.com/t5/QlikView/Availability-by-Date/m-p/644760#M236299 MK_QSL 2014-06-09T13:41:29Z Re: Re: Availability by Date https://community.qlik.com/t5/QlikView/Availability-by-Date/m-p/644761#M236300 <HTML><HEAD></HEAD><BODY><P>May be something like the attached</P></BODY></HTML> Mon, 09 Jun 2014 14:07:47 GMT https://community.qlik.com/t5/QlikView/Availability-by-Date/m-p/644761#M236300 CELAMBARASAN 2014-06-09T14:07:47Z Re: Availability by Date https://community.qlik.com/t5/QlikView/Availability-by-Date/m-p/644762#M236301 <HTML><HEAD></HEAD><BODY><P>Excellent... I was an inch away ... <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Mon, 09 Jun 2014 14:32:21 GMT https://community.qlik.com/t5/QlikView/Availability-by-Date/m-p/644762#M236301 MK_QSL 2014-06-09T14:32:21Z