Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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;