Continuous Axis Format Settings in Qlik™ Bar Chart

In this article we share some of the challenges we encountered working with bar charts in QlikView™ and the solutions we found.

In a bar chart with one date as dimension (x-axis), when all the data is displayed, the data is so crowded that it is not visually distinguishable. If we want to show all the data, without limiting the number of visible points on the x-axis plus the scroll option, the only way to enable static scale limits (min, max & step) is to use the continuous scale option. However, once you switch to a continuous scale, the data is no longer presented with numeric date formatting, but becomes simple numbers (e.g. 40963, instead of DD-MM-YYYY).

Tried Solutions:
The inclusion of the Date() formatting function in Calculated Dimension did not make any difference!
(Continuous axes only work with numeric values, and since data are numeric values, the graph represents them as such.)

Did you ever find a way to make a date axis continuous but still have it labeled with text?

The Complete Solution:
You can make the Date continuous and still present the X axis formatted what.
Steps to follow:

1. Right-click on the chart you are working on, then Properties

2.In the Axes tab
      a. in the Dimension Axes section
      b. check the Continuous box

3.In the Number tab
      a. Select “Continuous X-axis“,
      b. Then tick Date
      c. If necessary, edit in Pattern Format

You can see the result below.

Extra tip:
In order to have the values written obliquely on the X axis, we have activated in the Axes tab, in the Dimension Axis section, next to Primary Dimension Label, the 2nd option ( = / )

For information about Qlik™, please visit this site:
For specific and specialized solutions from QQinfo, please visit this page: QQsolutions.
In order to be in touch with the latest news in the field, unique solutions explained, but also with our personal perspectives regarding the world of management, data and analytics, we recommend the QQblog !