topic Missing hours/create a new axis in QlikView

Missing hours/create a new axis

Fri, 24 Sep 2010 15:27:38 GMT

Dear All

Can anybody please suggest me a way to add a 24 hour axis to the chart, in a way that all 24 hours are shown and the time between 1.00 and 7.00 is evenly distributed?

Thank you in advance.

Missing hours/create a new axis

Fri, 24 Sep 2010 15:32:41 GMT

I ques you only have value's until 16:00.

Missing hours/create a new axis

Fri, 24 Sep 2010 15:58:50 GMT

The values always change, because there is an update every 15 minutes. The table is updated daily, basically all values are reset to 0 after midnight.

Thanks.

Missing hours/create a new axis

pover — Fri, 24 Sep 2010 16:03:28 GMT

First, if all the hours don't exist in the data model, you should add hours to the data model and link it to the hour column in your transactions table. For example:

LOAD maketime(rowno()-1) AS HOUR
AUTOGENERATE 24;

Then in the graph and in the presentation tab, disable the option to suppress zero values and to suppress missing values. You might also have to select the option to show all values in the dimension tab.

Regards.

Missing hours/create a new axis

Fri, 24 Sep 2010 16:28:55 GMT

Dear Karl

You are a star! It works! I had created the 'hours' table myself, but I could not see the values because I hadn't clicked on suppressed zero values!

Thank you again!