Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Evan0211
Creator II
Creator II

Bar Chart X-Axis inconsistent date segments

I have a horizontal bar chart that shows project duration, starting with today as zero.  

The issue is that the x-axis is not consistent.  (see attached photo)

Evan0211_0-1646756403487.png

 

What I would prefer is to have it in a consistent format, preferably by months.  I can't seem to find a way to format it.   The range is currently set to min/max

Mix is Today()

Max is set to =Max(Date(COMPLETION_DATE))

The scale is set to Narrow.

Any ideas would be appreciated

Labels (1)
1 Solution

Accepted Solutions
Andrea_Spinetti
Former Employee
Former Employee

Hey 👋 Thank you for posting in our community! If I got your request right you could set 2 dimensions in the bar chart instead of just the "Date" field. The first dimension functioning as a Group could be "Month(Date)" and the second dimension the actual Date filed. This way you should obtain the dates grouped and labeled by month on the X-axis 😊

If the issue is solved please mark the answer with Accept as Solution.

View solution in original post

1 Reply
Andrea_Spinetti
Former Employee
Former Employee

Hey 👋 Thank you for posting in our community! If I got your request right you could set 2 dimensions in the bar chart instead of just the "Date" field. The first dimension functioning as a Group could be "Month(Date)" and the second dimension the actual Date filed. This way you should obtain the dates grouped and labeled by month on the X-axis 😊

If the issue is solved please mark the answer with Accept as Solution.