
Contributor III
2021-02-10
03:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
24 hour timeline
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!
764 Views
1 Reply

Creator II
2021-02-10
03:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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;
750 Views
