Skip to main content

Water Cooler

This space is for everyone to ask questions related to the Community Platform. It's a space for us to get to know each other and have some fun! Come in and gather around the Water Cooler!

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
s10157754
Creator III
Creator III

Qlikview Creating Time Line Chart

Dear Qlikview Experts,

I have this set of data.

test.PNG

First Column is the Date & Time and second column is the value either '1' or '0'. I would like to create a time line chart to display the data similar like below:

Capture.PNG

Any ideas on how to create this type of chart? Appreciating your time and effort in advance! 

Attached sample working file for your reference.

Best Regards 

QianNing

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hi

attach is an example , 

hope this what you look for 

View solution in original post

3 Replies
lironbaram
Partner - Master III
Partner - Master III

hi

attach is an example , 

hope this what you look for 

s10157754
Creator III
Creator III
Author

Dear LironBaram,

Thank you for your prompt reply, your solution works like a charm!

PS: May I know how can i have time interval to be every 1 hr instead of every 2 hr? So that i can change according to my own needs. 

Best Regards

QianNing

lironbaram
Partner - Master III
Partner - Master III

hi

in the chart properties 

go to the axes tab

there in the bottom right side , check the static step box and insert  =1/24 as the expression