Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm new to Qlikview.
hour( '09:14:36' ) returns 9
hour( '0.5555' ) returns 13 ( Because 0.5555 = 13:19:55 )
Can anyone explain how QlikView interprets 0.5555 as '13:19:55' in case of Date and Time Functions?
Regards,
Sudharshan
0.5555 * 24hours = '13:19:55'