Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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.