
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to get only integer numbers on y axis?
Hi,
I have developed simple bar chart which shows number of produced pieces in periods. Problem is that Qlik displays fractional numbers on Y axis what makes no sense for PCS unit - see atatched print screen.
Numbers on Y axis should always be integer. Have you an idea how to format Y axis to display only integer numbers?
Thanks in advance for support:)
Piotr
- Tags:
- bar chart
Accepted Solutions


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I took your app, selected last 30 days, set the number formatting to number, and this is what I get:


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
You need to adjust your measure's number format to integer.
Hope this helps

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Unfortunately, it dosn't solve my problem. If I change the measure's number format to integer then Qlik displays "1" instead of "0,5", so I get double '"1" value on Y axis, what is even worst solution. Please, see attached print screen.
Best regards, Piotr


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Funny, I am using QS June2020 Patch 1, and it seems fine to me:
Can you share your app?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
My version is QS November 2019, Patch 1. Maybe it is a reason(?).
Another reason could be that you use 'Wide' scale of Y axis:
But anyway, I have attached simple version of my application. Please select last 30 days of data range to replicate this issue.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I took your app, selected last 30 days, set the number formatting to number, and this is what I get:

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
So, it looks the QS version makes difference. I will talk to my Admin's to update it.
Thank you for support.
