24 hour timeline

[bartwelvaarts]

hello friends of the qlik community,

I would like to create a timeline from 00:00 to 24:00, even though if there is no data. At the moment i have 'gaps' in the timeline because there is no data of a particular time, see example below. it also does not go up to 24:00 becuase there is not data. Does someone have any to tackle this?

thanks in advanced!

[PradeepK]

You can create master time dimension.. 

Below is a basic script to create it..

// Hrs & Mins
Load
	Time(RecNo()/(24*60)) as time
AutoGenerate 24*60;

//Hrs
Load
	Time(RecNo()/24) as time
AutoGenerate 24;