topic Display current time in 12 hour format with AM/PM in QlikView

Display current time in 12 hour format with AM/PM

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a Date_D field and it has date and Time field. I want to create a bar chart to see how many call we do each hour in a day....how to create time expression.....

I am trying ..... class(time(Date_D,2) as my time expression....but it is not showing AM and PM in format..

Thanks in Advance

Sid

Re: Display current time in 12 hour format with AM/PM

marcus_sommer — Tue, 28 Jun 2016 08:20:15 GMT

Try something like this:

class(time(frac(Date_D), 'hh:mm:ss tt'), 1/24 * 2)

respectively reverse:

time(class(frac(Date_D), 1/24 * 2), 'hh:mm:ss tt')

- Marcus

Re: Display current time in 12 hour format with AM/PM

Tue, 28 Jun 2016 13:37:47 GMT

Hi Marcus,

Thanks for you reply !!!

What I needed was like ....

Hour	frequency
8 AM-10 AM	20
10 AM-12PM	19
12 PM - 2 PM	21
2 PM-4 PM	16

Re: Display current time in 12 hour format with AM/PM

marcus_sommer — Wed, 29 Jun 2016 07:28:05 GMT

You mean you want a condition to show only certain time-buckets and they should be displayed in a very special format then it might be better to use if-loops for defining the buckets or even better a pick(match()) like:

pick(match(hour(frac(Date_D)), 8,9,10,11,12,13,14,15),

'8 AM - 10 AM',

'10 AM - 12 PM',

....)

and then hiding NULL on these dimension.

- Marcus

Re: Display current time in 12 hour format with AM/PM

Wed, 29 Jun 2016 08:20:04 GMT

Thanks Marcus !!! you are a saviour !!!