topic Time issue in QlikView

Time issue

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi guys ,

I have data source like this

I had used Gantt chart for show jobs time duration like below image

I have given an expression as =Max(endTime)-Min(Starttime) and in Bar offset =Min(Starttime)

Its showing the data correctly up to PM to PM time if the jobs runs Start time is 11:02 PM and jobs end in 2:06 AM the chart is not showing properly so what kind of condition i have to give if start time starts with PM and End with AM could any one Please help me out from this scenario

Regards,

Vijay.M

Message was edited by: Vijay Malaisamy

Re: Time issue

Anil_Babu_Samineni — Thu, 20 Apr 2017 14:48:48 GMT

Would you able to share sample

Re: Time issue

Anonymous — Thu, 20 Apr 2017 15:29:38 GMT

ya i shared the qvw file please check it

Re: Time issue

Anonymous — Thu, 20 Apr 2017 16:47:56 GMT

Hi,

could anyone give solution for this requirement,

Regards,

Vijay.M

Re: Time issue

rodjager — Fri, 21 Apr 2017 01:36:29 GMT

Hi Vijay,

Nice start. The main issue is that your times cross days and your data does not appear to contain a date so you need to treat the times as intervals with an assumption that an interval is a day or less in size.

Therefore, to fix your gantt chart I would suggest the following:

1. Expressions tab: change your expression for Duration to test the times. this would look like:

if(max(endTime) > min(Starttime),
max(endTime) - min(Starttime),
(1+max(endTime)) - min(Starttime)
)

2. Axes tab: Uncheck the Static Max option and let QlikView work this out

3. Number tab: Set the format of Duration to Interval and then remove the TT suffix from the Format Pattern box to drop the AM/PM on the x axis.

Hope this helps.

Rod