Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III

extract field

Hello nice people,

I have a date field in my database that contains date and time

Capture.PNG

I would like to extract only time to display it in QlikView.

Any idea, how to do that?

Thanks

11 Replies
ToniKautto
Employee
Employee

Anil, I am not sure you understand the formatting logic in QlikView.

A proper time is represented by a decimal value, where integer is a zero. A timestamp is a decimal value, where integer is not a zero. Converting a timestamp into a time value requires using Frac() to remove the non-zero integer value.

By using Time() or Time#() you will apply proper meta data tags to your time data, which means the data will be tagged as time. It also means that the functions by default will apply the TimeFormat variable value as its format pattern, which means you do not have to type the format pattern every time you convert data. This make you script easier to maintain, and mean you control the output format from your format variable and not in a each function call.

ToniKautto
Employee
Employee

This will not generate a proper time value, for the third time in this thread.