I have a bar chart with a date as a dimension (x-axis). Currently when I show all of my data, the dates are so crammed up together that they are not visually distinguishable. I want to show all of the data (i.e. not limit and put a scrollbar) but would like to make the step 5 days in stead of every day. The only way I can see to enable the static min, max and step expressions are to use the continuous scale option. This is fine and I can change the step. The issue is that when switching to continuous, the dates are now visualised as date numbers (i.e. 40963) rather than an actual date.
Continuous axes only work with numeric values, and since dates are numeric values, the chart represent them as such. But in version 10 SR2 on, at least, you can configure the X-Axis format in the chart properties, Number, "Continuous X-Axis".
Hope that helps.
I am running 10 SR2 and cannot find this option. I only have the option under Axis> Continuous. The number tab only allows me to change the number formats of Expressions, not dimensions.
Also, the date function makes no difference on the dimension when used...
Is there any other way that you know of? Simple thing really just changing the step of a date scale... another time when QV and dates don't play nice.
Hi Miguel Angel Baeyens,
In your example, I did not find how you converted the numbers into date. i.e. then set the Continious porperty, we actually are seeing the dates like Jan 2011, but the underllying field is actually a number. how did this conversion happen? can you please explain?
All dates in QlikView are represented by a string, for example 'Feb 8, 2012' although they are interpreted as a number, so you can add a figure to a date, for example, if you use this in a text object, it will return "09/02/2012" which is correct. The reason is that the real value that QlikView stores is numeric.
Hope that helps.
You can make Date continuous and still set the date format you want. You need to
1.) Check Continuous box on the Dimension Axes on the Axes tab.
2.) Set the "Continuous X-axis" expression to Date on the Number tab.