Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

haymarketpaul
Contributor III

How to display a 24 hour timeline chart?

Hi there

I have some data that details the date and time a client email was read.

I would like to create a timeline chart where the x-axis spans 24 hours and the y-axis is a count of uid so i can display at what time of day most emails are read by our clients.

So the x-axis would have increments like

00:00 - 01:00

01:00 - 02:00

02:00 - 03:00

etc...

23:00 - 00:00

I would still like to display each increment regardless of whether data exists for that timeframe.

I have tried a couple of approaches to get this to work which you will see in the attached qvw on the main tab but i am struggling to make sense of what i am doing wrong?  The data in my hour field just looks weird?

For data sensitivty reasons i have removed the actual email address data from the attached qvw.  I have also commented out parts of the script that were unrelated to make it easier for someone to view and hopefully help.

Any help/pointers greatly appreciated.

Paul

Tags (2)
1 Solution

Accepted Solutions
haymarketpaul
Contributor III

How to display a 24 hour timeline chart?

Don't worry i worked it out...

I was extremely stupidly missing some commas in the load inline part of the script

4 Replies
haymarketpaul
Contributor III

How to display a 24 hour timeline chart?

Don't worry i worked it out...

I was extremely stupidly missing some commas in the load inline part of the script

lironbaram
Honored Contributor II

Re: How to display a 24 hour timeline chart?

hei
you have a problem in your inline table
it should be written like this
replace your current inline with this one
LOAD
* INLINE [
Hour, Hour_Min, Hour_Range
0, 00:00, 00:00-01:00
1, 01:00, 01:00-02:00
2, 02:00, 02:00-03:00
3, 03:00, 03:00-04:00
4, 04:00, 04:00-05:00
5, 05:00, 05:00-06:00
6, 06:00, 06:00-07:00
7, 07:00, 07:00-08:00
8, 08:00, 08:00-09:00
9, 09:00, 09:00-10:00
10, 10:00, 10:00-11:00
11, 11:00, 11:00-12:00
12, 12:00, 12:00-13:00
13, 13:00, 13:00-14:00
14, 14:00, 14:00-15:00
15, 15:00, 15:00-16:00
16, 16:00, 16:00-17:00
17, 17:00, 17:00-18:00
18, 18:00, 18:00-19:00
19, 19:00, 19:00-20:00
20, 20:00, 20:00-21:00
21, 21:00, 21:00-22:00
22, 22:00, 22:00-23:00
23, 23:00, 23:00-00:00
]
;
haymarketpaul
Contributor III

Re: How to display a 24 hour timeline chart?

yes i spotted that too - thanks for replying

luisdarwinqlik
New Contributor

Re: How to display a 24 hour timeline chart?

Hi Haymarketpaul,

I was wondering if you could share to me how was that you fixing your script to solve the problem. I have a similar doubt that how link time and show time charts, It could be useful for my case.

Thank in advanced

Luis

Community Browser