topic How can i change Number to Hour format in QlikView https://community.qlik.com/t5/QlikView/How-can-i-change-Number-to-Hour-format/m-p/43395#M769028 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>How can i change Number to Hour format </P><P></P><P><IMG alt="Screenshot_3.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/204132_Screenshot_3.png" style="height: auto;" /></P><P></P><TABLE border="1" class="jiveBorder" height="199" style="border: 1px solid rgb(0, 0, 0); width: 65px; height: 158px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Data</STRONG></TH></TR><TR><TD style="padding: 2px;">9.0</TD></TR><TR><TD style="padding: 2px;">9.5</TD></TR><TR><TD style="padding: 2px;">10.0</TD></TR><TR><TD style="padding: 2px;">10.5</TD></TR><TR><TD style="padding: 2px;">11.0</TD></TR><TR><TD style="padding: 2px;">11.5</TD></TR><TR><TD style="padding: 2px;">12.0</TD></TR><TR><TD style="padding: 2px;">12.5</TD></TR><TR><TD style="padding: 2px;">13.0</TD></TR><TR><TD style="padding: 2px;">13.5</TD></TR><TR><TD style="padding: 2px;">14.0</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT vengadeshpalani 2020-11-25T16:16:04Z How can i change Number to Hour format https://community.qlik.com/t5/QlikView/How-can-i-change-Number-to-Hour-format/m-p/43395#M769028 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>How can i change Number to Hour format </P><P></P><P><IMG alt="Screenshot_3.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/204132_Screenshot_3.png" style="height: auto;" /></P><P></P><TABLE border="1" class="jiveBorder" height="199" style="border: 1px solid rgb(0, 0, 0); width: 65px; height: 158px;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Data</STRONG></TH></TR><TR><TD style="padding: 2px;">9.0</TD></TR><TR><TD style="padding: 2px;">9.5</TD></TR><TR><TD style="padding: 2px;">10.0</TD></TR><TR><TD style="padding: 2px;">10.5</TD></TR><TR><TD style="padding: 2px;">11.0</TD></TR><TR><TD style="padding: 2px;">11.5</TD></TR><TR><TD style="padding: 2px;">12.0</TD></TR><TR><TD style="padding: 2px;">12.5</TD></TR><TR><TD style="padding: 2px;">13.0</TD></TR><TR><TD style="padding: 2px;">13.5</TD></TR><TR><TD style="padding: 2px;">14.0</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-can-i-change-Number-to-Hour-format/m-p/43395#M769028 vengadeshpalani 2020-11-25T16:16:04Z Re: How can i change Number to Hour format https://community.qlik.com/t5/QlikView/How-can-i-change-Number-to-Hour-format/m-p/43396#M769030 <HTML><HEAD></HEAD><BODY><P>Just do this</P><P></P><P><STRONG>Time(Data/24, 'h:mm') as Data</STRONG></P></BODY></HTML> Fri, 01 Jun 2018 14:27:45 GMT https://community.qlik.com/t5/QlikView/How-can-i-change-Number-to-Hour-format/m-p/43396#M769030 sunny_talwar 2018-06-01T14:27:45Z Re: How can i change Number to Hour format https://community.qlik.com/t5/QlikView/How-can-i-change-Number-to-Hour-format/m-p/43397#M769031 <HTML><HEAD></HEAD><BODY><P>Try it with: time(1/24 * [Data]) as [Hour]</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 01 Jun 2018 14:28:02 GMT https://community.qlik.com/t5/QlikView/How-can-i-change-Number-to-Hour-format/m-p/43397#M769031 marcus_sommer 2018-06-01T14:28:02Z