Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Regards,
Vijay.M
Message was edited by: Vijay Malaisamy
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
Would you able to share sample
ya i shared the qvw file please check it
Hi,
could anyone give solution for this requirement,
Regards,
Vijay.M
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