Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
charmon010
Contributor
Contributor
‎2020-06-03 01:35 PM

Time Format

I have a time field that is a Char(18) from the source db.

When I bring it into Qlikview the format is 00.00.00.000000

How do I translate it to a true TIME format?  I have tried several variations but the all come back as "-". 

 

 

Labels (1)
Labels
714 Views
0 Likes
3 Replies
sergio0592
Specialist III
Specialist III
‎2020-06-03 02:42 PM

Have you tried with time# function?

686 Views
0 Likes
charmon010
Contributor
Contributor
‎2020-06-03 02:56 PM
Author

In response to sergio0592

Yes.  It does not return at number.

683 Views
0 Likes
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP
‎2020-06-04 12:49 AM

In response to charmon010

Can you post the time#() function you have tried?

-Rob

659 Views