Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
The above chart is a pivot table, The background color changes based on the task being performed
The times at the top are the start times of the task.
My question is how can I get a more seamless chart, basically I would like the chart to always have the 24 hours in a day but with the tasks colored where it fits in with the time of the day.
I hope that makes sense.
Regards
Alan
Thanks Aunez,
I will try this and revert
Thanks again
Regards
Alan
Well,
try Henric's solution first. It is certainly more robust (I did not see he had answered). But you got the way to do it.
Fabrice
Hi Alan,
I'm recommending this article by just reading the subject line. And also read Henric's post:
http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates
and one more very useful post
http://iqlik.wordpress.com/2011/05/22/a-new-choice-of-armor-the-flag-matrix/
Thanks,
DV
Thanks Deepak