Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Luke_Killer_IT
Creator
Creator

how convert number to time

hello  i have problem I want see time  but i see number;

Luke_Killer_IT_0-1632729007953.png

I used code

= Interval( V_SendungKopf.uCW_AbfahrtZeit/24/60,'hh:mm')

but i see this:

Luke_Killer_IT_1-1632730675582.png

this time is wrong it should be 05:15

 

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Try like:

=Time(Time#(V_SendungKopf.uCW_AbfahrtZeit ,'hhmm'),'hh:mm')

View solution in original post

2 Replies
tresesco
MVP
MVP

Try like:

=Time(Time#(V_SendungKopf.uCW_AbfahrtZeit ,'hhmm'),'hh:mm')

Luke_Killer_IT
Creator
Creator
Author

thank for your help