topic Re: How to display a 24 hour timeline chart? in QlikView

How to display a 24 hour timeline chart?

haymarketpaul — Mon, 03 Oct 2011 10:21:07 GMT

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

How to display a 24 hour timeline chart?

haymarketpaul — Mon, 03 Oct 2011 10:42:49 GMT

Don't worry i worked it out...

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

Re: How to display a 24 hour timeline chart?

lironbaram — Mon, 03 Oct 2011 10:45:32 GMT

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
];

Re: How to display a 24 hour timeline chart?

haymarketpaul — Mon, 03 Oct 2011 10:46:38 GMT

yes i spotted that too - thanks for replying

Re: How to display a 24 hour timeline chart?

luisdarwinqlik — Wed, 26 Dec 2018 15:35:02 GMT

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