topic Qlikview Creating Time Line Chart in Water Cooler

Qlikview Creating Time Line Chart

s10157754 — Tue, 15 Jan 2019 07:02:36 GMT

Dear Qlikview Experts,

I have this set of data.

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:

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

Re: Qlikview Creating Time Line Chart

lironbaram — Tue, 15 Jan 2019 07:27:04 GMT

attach is an example ,

hope this what you look for

Re: Qlikview Creating Time Line Chart

s10157754 — Tue, 15 Jan 2019 07:54:25 GMT

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

Re: Qlikview Creating Time Line Chart

lironbaram — Tue, 15 Jan 2019 08:59:43 GMT

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