topic Re: Date and time in Qliksense in App Development

Date and time in Qliksense

Mamta123 — Wed, 22 Dec 2021 15:54:26 GMT

I have date column in the format given below:

1/1/2019 4:34:00 AM

From the data extracted, I need to count the number of tickets created between 4.00 am Last day and 4.00 PM today.

I need to include time and date in the calculation.The calculation is used in one of the visualization.

Re: Date and time in Qliksense

Vegar — Mon, 02 Mar 2020 12:36:31 GMT

I would consider introducing a new business day field (consider it as date version of fiscal year).

Take a look at my script and the output shown in picture below.

SET TimestampFormat='M/D/YYYY hh:mm:ss TT'; Output: LOAD DayName(RecordedTime,0, time#(4, 'h') ) as BusinessDay, DayName(RecordedTime) as CalendarDay, RecordedTime inline [ RecordedTime 1/1/2019 4:34:00 AM 2/1/2019 4:40:00 AM 2/1/2019 3:34:00 AM 3/1/2019 3:34:00 AM 3/1/2019 06:37:00 PM 4/1/2019 01:37:00 AM 4/1/2019 03:37:00 AM 4/1/2019 08:37:00 PM 4/1/2019 11:37:00 PM 4/1/2019 07:37:00 AM ];

Re: Date and time in Qliksense

Mamta123 — Tue, 03 Mar 2020 10:28:28 GMT

The BusinessDay is not showing up

I have used the code:

Timestamp(Timestamp#([LastUpdated], 'M/D/YYYY hh:mm') ) AS [LU],
Timestamp(Timestamp#([ProcessCreationDate], 'M/D/YYYY hh:mm') ) AS [TestData],
DayName(TestData,0, time#(4, 'h')) as [BusinessDay]

Re: Date and time in Qliksense

Vegar — Wed, 04 Mar 2020 06:28:16 GMT

Does your TestData turn out correct? If so then you could try this.

DayName(Timestamp#([ProcessCreationDate], 'M/D/YYYY hh:mm'),0, time#(4, 'h')) as [BusinessDay]

Re: Date and time in Qliksense

Mamta123 — Wed, 04 Mar 2020 09:24:06 GMT

Thank you Vegar !! It was great help 🙂