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: 
piotrtk
Contributor II
Contributor II

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

Labels (2)
1 Solution

Accepted Solutions
fosuzuki
Partner - Specialist III
Partner - Specialist III

I took your app, selected last 30 days, set the number formatting to number, and this is what I get:

Capture.PNG

View solution in original post

6 Replies
fosuzuki
Partner - Specialist III
Partner - Specialist III

Hi,

You need to adjust your measure's number format to integer.

 

Hope this helps

piotrtk
Contributor II
Contributor II
Author

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

fosuzuki
Partner - Specialist III
Partner - Specialist III

Funny, I am using QS June2020 Patch 1, and it seems fine to me:

Capture.PNG

 

Can you share your app?

piotrtk
Contributor II
Contributor II
Author

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:
Bar chart issue 3.JPG

But anyway, I have attached simple version of my application. Please select last 30 days of data range to replicate this issue. 

fosuzuki
Partner - Specialist III
Partner - Specialist III

I took your app, selected last 30 days, set the number formatting to number, and this is what I get:

Capture.PNG

piotrtk
Contributor II
Contributor II
Author

So, it looks the QS version makes difference. I will talk to my Admin's to update it. 

Thank you for support.