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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ioannaiogr
Creator II
Creator II

weird step on x axis in chart (picture attached)

Hi all,

as you can see in my chart i have double ones, double twos, etc. Didn't do anything different than what  I normally do!

Any ideas why this happens 🤔

Q.png

Labels (3)
1 Solution

Accepted Solutions
Anku
Creator
Creator

@ioannaiogr 

Go to your Measure > Number Formatting > Select Number > Turn on Formatting > Select decimal.

Or Use Floor function in your script.

It will help if you share the snapshot of your data source.

 

View solution in original post

4 Replies
Or
MVP
MVP

Something's forcing the chart to format as a whole number, but it found the best way to split the axis as 0.5. The underlying values are actually 1, 1.5, 2, 2.5, etc.

 

Anku
Creator
Creator

@ioannaiogr 

Go to your Measure > Number Formatting > Select Number > Turn on Formatting > Select decimal.

Or Use Floor function in your script.

It will help if you share the snapshot of your data source.

 

ioannaiogr
Creator II
Creator II
Author

You both are right! I have absolutely no clue though why qlik "thought" this count  is a decimal... 😆 Problem partially solved, because I would prefer for the chart to show only whole numbers and not decimals like 1,00 , 2,00 etc.

 

But thanks both so much! Always helpful. 

Anku
Creator
Creator

Do one thing, go to appearance and turn on the data label then hide the axis value. Hope it will look better.