topic Re: Help creating Field in QlikView https://community.qlik.com/t5/QlikView/Help-creating-Field/m-p/302145#M1180645 <HTML><HEAD></HEAD><BODY><P>it could be usefull, if there would be some form of&nbsp; a calendar </P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 40%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>room</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>month</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>day</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>value</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>f.e. notes</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>2</TD><TD>1</TD><TD>aviable</TD><TD></TD></TR><TR><TD>1</TD><TD>2</TD><TD>3</TD><TD>aviable</TD><TD></TD></TR><TR><TD>1</TD><TD>3</TD><TD>1</TD><TD>booked</TD><TD></TD></TR><TR><TD>1</TD><TD>3</TD><TD>2</TD><TD>cleaning</TD><TD></TD></TR><TR><TD>2</TD><TD>3</TD><TD>5</TD><TD>aviable</TD><TD></TD></TR></TBODY></TABLE><P></P><P>the main problem could be the exact reading of the '.' separated chars.</P></BODY></HTML> Tue, 21 Feb 2012 11:54:32 GMT 2012-02-21T11:54:32Z Help creating Field https://community.qlik.com/t5/QlikView/Help-creating-Field/m-p/302144#M1180644 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I need some assistance with this please.</P><P></P><P>Lets say, in my model, I am providing a hotel with info regarding their business.</P><P></P><P>Now I have a room, and also the <STRONG>usage</STRONG> of this room, per day, per week. Lets say, this room is only available <STRONG>Monday</STRONG>, and <STRONG>Wednesday</STRONG>.</P><P>So if Monday is day 1, and Wednesday day 3, they give me this pattern in their Data source file (xls)...</P><P>Room1, <STRONG>1.3.... </STRONG>(one char for each day)</P><P></P><P>I dont know how to represent this usage in a clear way, because obviously, they would like to see which rooms have the highest occupancy.</P><P></P><P>Any ideas please?</P><P></P><P>Thanx!</P></BODY></HTML> Tue, 21 Feb 2012 07:27:25 GMT https://community.qlik.com/t5/QlikView/Help-creating-Field/m-p/302144#M1180644 2012-02-21T07:27:25Z Re: Help creating Field https://community.qlik.com/t5/QlikView/Help-creating-Field/m-p/302145#M1180645 <HTML><HEAD></HEAD><BODY><P>it could be usefull, if there would be some form of&nbsp; a calendar </P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 40%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>room</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>month</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>day</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>value</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>f.e. notes</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>2</TD><TD>1</TD><TD>aviable</TD><TD></TD></TR><TR><TD>1</TD><TD>2</TD><TD>3</TD><TD>aviable</TD><TD></TD></TR><TR><TD>1</TD><TD>3</TD><TD>1</TD><TD>booked</TD><TD></TD></TR><TR><TD>1</TD><TD>3</TD><TD>2</TD><TD>cleaning</TD><TD></TD></TR><TR><TD>2</TD><TD>3</TD><TD>5</TD><TD>aviable</TD><TD></TD></TR></TBODY></TABLE><P></P><P>the main problem could be the exact reading of the '.' separated chars.</P></BODY></HTML> Tue, 21 Feb 2012 11:54:32 GMT https://community.qlik.com/t5/QlikView/Help-creating-Field/m-p/302145#M1180645 2012-02-21T11:54:32Z