topic Time Calender as X-axis in a Diagram in QlikView

Time Calender as X-axis in a Diagram

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

Hi, there.

I have a dataset, in which there is a column called Time. I have many times in form 'hh:mm:ss'. For every second I have 1 or some product ID. For sometime I have no product. It's a production dataset.

Now I have a Time Calender.

I want to make a Lines diagram. X-axis shows Time Calender for every second. Y-axis shows Count(ID).

That means I want to show how maný products for every second. But It not works. Attach is a test.

Thank you.

Regrads

Re: Time Calender as X-axis in a Diagram

sunny_talwar — Fri, 13 Jul 2018 13:48:04 GMT

Have you tried unchecking 'Suppress Zero Values' from the presentation tab?

Re: Time Calender as X-axis in a Diagram

tomcatxx — Fri, 13 Jul 2018 14:01:03 GMT

Thank you. I tried it. But it is not the point.

It shows only some timestamps on X-Axis. In that example, I have only 00:00:00, 00:00:13, 00:00:41, 00:00:51 .....for X-Axis in diagram. What I want is 00:00:00, 00:00:01, 00:00:02, 00:00:03 ..... every second on X-Axis.

Re: Time Calender as X-axis in a Diagram

sunny_talwar — Fri, 13 Jul 2018 14:08:23 GMT

Isn't this what you want?

Re: Time Calender as X-axis in a Diagram

tomcatxx — Fri, 13 Jul 2018 14:27:05 GMT

Cool. Can u explan Time(Round(Time_From_Data, 1/86400)) for me. Thank you.

Re: Time Calender as X-axis in a Diagram

sunny_talwar — Fri, 13 Jul 2018 14:36:29 GMT

It seems that the time from your main file might be rounded off to the seconds... which is why we were seeing two 00:00:01s (and others too)... so, in order to combine them, I just rounded it off to the closest second. and Time() is just used for formatting.