Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
dominicanlauf
Contributor III
Contributor III

hour function with decimal places

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

 

1 Solution

Accepted Solutions
tresesco
MVP
MVP

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

 

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

View solution in original post

2 Replies
tresesco
MVP
MVP

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

 

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

View solution in original post

dominicanlauf
Contributor III
Contributor III

Great, thanks!