Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

akellaart
New Contributor

Axis with dates

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).

Снимок.PNG

Thanks in advance!

2 Replies
shiveshsingh
Honored Contributor

Re: Axis with dates

What are you trying to measure? What is Fact?

akellaart
New Contributor

Re: Axis with dates

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