Discussion board where members can learn more about Qlik Sense App Development and Usage.
I am looking for simple way to display Timestamp data for Integer values.
Like 1 = 24:00:00, 2 = 48:00:00, etc
Using Time() or TimeStamp() does not help, it's always displaying 00:00:00 for the whole numbers.
I do not want to use IFs or similar approach, I was hoping it could be achieved much more elegant way...
Replace Time with Interval !
View solution in original post
About your question, make sure your field is formatted as number. Try this out:
But it did not help much:
Here is my code:
let vStep = 1;
set vTrace = 'The Requested Step value = ' & num($(vStep)) & ' or ' & Time(num#('$(vStep)'), 'hh:mm:ss')
The Requested Step value = 1 or 00:00:00
If you put in context your end goal it might help.
time values are < 1, so any whole number will have 0 time.
As shown in Help, 0.375 = 09:00
How the !@#!@ I forgot about that function???