Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

arsallee3
New Contributor III

Master Time Table

I am working to chart items by hour and having some difficulties in getting the output I want.

Pulling data from a SQL table with single date/time stamp field.

I can chart by hour with no problem, however I have hours that I have no data and would like to have this reflected in the hourly chart.

I have tried creating Master time table still not able to get the results that I would like.

1 Solution

Accepted Solutions
arsallee3
New Contributor III

Re: Master Time Table

I did have the hour as a dimension already however I do not see way to set to Continuous.

The alternative formula did achieve the result for me though.

Thanks,

Andy

2 Replies
Employee
Employee

Re: Master Time Table

If you create a field "hour", use this as dimension in your graph, and set the axis as "Continuous" (on Axis sheet) you will have holes in your graph on the hours where there is no data.

An alternative is to use

   Sum(Data) + 0*Sum({1} Data)

instead of

   Sum(Data)

as expression, and remove "Suppress zero values" on the Presentation tab. This will force all dimensional values to be displayed, also the ones without data..

HIC

arsallee3
New Contributor III

Re: Master Time Table

I did have the hour as a dimension already however I do not see way to set to Continuous.

The alternative formula did achieve the result for me though.

Thanks,

Andy