Qlik Community

Community Corner

Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!

s10157754
Contributor 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
Highlighted
Partner
Partner

Re: Qlikview Creating Time Line Chart

hi

attach is an example , 

hope this what you look for 

View solution in original post

3 Replies
Highlighted
Partner
Partner

Re: Qlikview Creating Time Line Chart

hi

attach is an example , 

hope this what you look for 

View solution in original post

s10157754
Contributor III

Re: Qlikview Creating Time Line Chart

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

Partner
Partner

Re: Qlikview Creating Time Line Chart

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