Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mellerbeck
Creator II
Creator II

Time format including AM/PM

I only see in the help Time(HH:MM:SS)

Anyone know how?

1 Solution

Accepted Solutions
Not applicable

Try this:

h:mm:ss tt   (if you want seconds)

h:mm tt  (if you do not want seconds)

View solution in original post

2 Replies
Not applicable

Try this:

h:mm:ss tt   (if you want seconds)

h:mm tt  (if you do not want seconds)

View solution in original post

Sokkorn
Master
Master

Hi,

I have two solution:

1. On Chart

Right Click on Chart --> Properites --> Select Number tab --> Select on Expression --> Check on Time for number formate setting.

2. Use function:

TIME(TimeField,'h:mm:ss TT')

Regards,

Sokkorn