topic Re: Format of time from variable in QlikView https://community.qlik.com/t5/QlikView/Format-of-time-from-variable/m-p/1363797#M835855 <HTML><HEAD></HEAD><BODY><P>Hello Anil,</P><P></P><P>I have to compare the value in variable with datepart hours. If I provide value in variable as 7 it compares properly but if I take it&nbsp; as 7:45 then it is throwing error about not specified ":" </P></BODY></HTML> Wed, 31 May 2017 06:58:44 GMT rahulken 2017-05-31T06:58:44Z Format of time from variable https://community.qlik.com/t5/QlikView/Format-of-time-from-variable/m-p/1363794#M835851 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have txt file contains variable declared in that file. I have assigned variable as "7" and it is working fine if I have to change it to "7:45" then it is not working. The variable should behave like time. Can any one please suggest me how to resolve it?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Format-of-time-from-variable/m-p/1363794#M835851 rahulken 2020-11-25T16:16:04Z Re: Format of time from variable https://community.qlik.com/t5/QlikView/Format-of-time-from-variable/m-p/1363795#M835853 <HTML><HEAD></HEAD><BODY><P>Please share some sample app.</P></BODY></HTML> Wed, 31 May 2017 06:24:31 GMT https://community.qlik.com/t5/QlikView/Format-of-time-from-variable/m-p/1363795#M835853 prma7799 2017-05-31T06:24:31Z Re: Format of time from variable https://community.qlik.com/t5/QlikView/Format-of-time-from-variable/m-p/1363796#M835854 <HTML><HEAD></HEAD><BODY><P>I am assuming you are defining in Input Box, When you entered as time it consider as Time itself. You have to re modify that in Variable Itself. If i am wrong, You would explain little more</P></BODY></HTML> Wed, 31 May 2017 06:54:50 GMT https://community.qlik.com/t5/QlikView/Format-of-time-from-variable/m-p/1363796#M835854 Anil_Babu_Samineni 2017-05-31T06:54:50Z Re: Format of time from variable https://community.qlik.com/t5/QlikView/Format-of-time-from-variable/m-p/1363797#M835855 <HTML><HEAD></HEAD><BODY><P>Hello Anil,</P><P></P><P>I have to compare the value in variable with datepart hours. If I provide value in variable as 7 it compares properly but if I take it&nbsp; as 7:45 then it is throwing error about not specified ":" </P></BODY></HTML> Wed, 31 May 2017 06:58:44 GMT https://community.qlik.com/t5/QlikView/Format-of-time-from-variable/m-p/1363797#M835855 rahulken 2017-05-31T06:58:44Z Re: Format of time from variable https://community.qlik.com/t5/QlikView/Format-of-time-from-variable/m-p/1363798#M835856 <HTML><HEAD></HEAD><BODY><P>That's for i mention Qlikview gives the output as always our inputs only. If you have 7 as variable stored then how you are enter 7:45. Still not confirmed the reason. Can you release the key as you required (May be images) then we can talk about the troubleshoot <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 31 May 2017 07:04:07 GMT https://community.qlik.com/t5/QlikView/Format-of-time-from-variable/m-p/1363798#M835856 Anil_Babu_Samineni 2017-05-31T07:04:07Z Re: Format of time from variable https://community.qlik.com/t5/QlikView/Format-of-time-from-variable/m-p/1363799#M835859 <HTML><HEAD></HEAD><BODY><P>Now I change the value in variable as "7:45" and then while comparing it is showing error. I am trying to upload the scenario.</P></BODY></HTML> Wed, 31 May 2017 07:06:33 GMT https://community.qlik.com/t5/QlikView/Format-of-time-from-variable/m-p/1363799#M835859 rahulken 2017-05-31T07:06:33Z Re: Format of time from variable https://community.qlik.com/t5/QlikView/Format-of-time-from-variable/m-p/1363800#M835862 <HTML><HEAD></HEAD><BODY><P>Would you able to provide Scenario. And that include you have to declare single quotes for that, May be like '7:45'</P></BODY></HTML> Wed, 31 May 2017 07:10:10 GMT https://community.qlik.com/t5/QlikView/Format-of-time-from-variable/m-p/1363800#M835862 Anil_Babu_Samineni 2017-05-31T07:10:10Z Re: Format of time from variable https://community.qlik.com/t5/QlikView/Format-of-time-from-variable/m-p/1363801#M835863 <HTML><HEAD></HEAD><BODY><P>Give it in single quotes. It will work</P></BODY></HTML> Wed, 31 May 2017 08:00:37 GMT https://community.qlik.com/t5/QlikView/Format-of-time-from-variable/m-p/1363801#M835863 Anonymous 2017-05-31T08:00:37Z Re: Format of time from variable https://community.qlik.com/t5/QlikView/Format-of-time-from-variable/m-p/1363802#M835864 <HTML><HEAD></HEAD><BODY><P>use Time() with Time#()</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">time(time#(TheTime,'h:mm')) as TheTime</SPAN></P></BODY></HTML> Wed, 31 May 2017 08:10:38 GMT https://community.qlik.com/t5/QlikView/Format-of-time-from-variable/m-p/1363802#M835864 vinieme12 2017-05-31T08:10:38Z