Axis with dates

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello everyone!

I'm trying to make a chart where X axis represents datetime, Y axis represents name of an object and inside there are stacked bars which are colored by Status.

For example sections from '01.01.2017 00:00:00' to '01.01.2017 00:20:00' of object A should be colored red and section from '01.2017 00:30:00' to '01.01.2017 00:40:00' of object A should be colored yellow.

I'm stacked at trying to display dates on X axis. What should I write in measures/dimensions?

I'm using the following sample data:

load * inline

[ DateTime, Object, Status

'01.01.2017 00:00:00', A, status1

'01.01.2017 00:10:00', A, status1

'01.01.2017 00:20:00', A, status1

'01.01.2017 00:30:00', A, status2

'01.01.2017 00:40:00', A, status2

'01.01.2017 00:50:00', A, status1

'01.01.2017 01:00:00', A, status3

'01.01.2017 01:10:00', A, status1

'01.01.2017 01:20:00', A, status1

'01.01.2017 01:30:00', A, status2

'01.01.2017 01:40:00', A, status3

'01.01.2017 01:50:00', A, status3

'01.01.2017 01:00:00', A, status3

'01.01.2017 00:00:00', B, status1

'01.01.2017 00:10:00', B, status1

'01.01.2017 00:20:00', B, status2

'01.01.2017 00:30:00', B, status2

'01.01.2017 00:40:00', B, status2

'01.01.2017 00:50:00', B, status2

'01.01.2017 01:00:00', B, status3

'01.01.2017 01:10:00', B, status1

'01.01.2017 01:20:00', B, status1

'01.01.2017 01:30:00', B, status2

'01.01.2017 01:40:00', B, status3

'01.01.2017 01:50:00', B, status1

'01.01.2017 01:00:00', B, status1

'01.01.2017 00:00:00', C, status1

'01.01.2017 00:10:00', C, status1

'01.01.2017 00:20:00', C, status1

'01.01.2017 00:30:00', C, status1

'01.01.2017 00:40:00', C, status1

'01.01.2017 00:50:00', C, status1

'01.01.2017 01:00:00', C, status3

'01.01.2017 01:10:00', C, status1

'01.01.2017 01:20:00', C, status1

'01.01.2017 01:30:00', C, status2

'01.01.2017 01:40:00', C, status3

'01.01.2017 01:50:00', C, status3

'01.01.2017 01:00:00', C, status3

];

Below is the chart I'm trying to make (x axis is wrong).

Thanks in advance!

Re: Axis with dates

shiveshsingh — Wed, 14 Feb 2018 06:24:40 GMT

What are you trying to measure? What is Fact?

Re: Axis with dates

Anonymous — Wed, 14 Feb 2018 07:30:31 GMT

There is no fact actually. I'm trying to color every 10 min section between dates.

topic Axis with dates in QlikView

Axis with dates

Re: Axis with dates

Re: Axis with dates