topic Re: hour function with decimal places in QlikView

hour function with decimal places

dominicanlauf — Wed, 25 Nov 2020 16:16:04 GMT

Hello everybody,

is there a opportunitiy to get decimal places from the hour function?

For example:

Timestamp: 02.05.2019 05:58:12

hour(timestamp) = 5

Now I want to get 5,97

Is this possible?

Thanks,

Dominic

tresB — Mon, 06 May 2019 07:46:29 GMT

Hour() won't give that. You can try like:

=Num(Frac(Timestamp)*24, '##.00')

dominicanlauf — Mon, 06 May 2019 08:00:11 GMT

Great, thanks!