Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Evan0211
Creator
Creator

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.