I need to create a seamless Time Dimension, based on Start Time

[rustyfishbones]

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

[rustyfishbones]

Thanks Aunez,

I will try this and revert

Thanks again

Regards

Alan

[#3]

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

[IAMDV]

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

[rustyfishbones]

Thanks Deepak