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?
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
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 as 7:45 then it is throwing error about not specified ":"
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
Would you able to provide Scenario. And that include you have to declare single quotes for that, May be like '7:45'