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

Announcements
Share your agentic AI experience, learn from others, and earn a new badge: Put Agentic AI to Work
cancel
Showing results for 
Search instead for 
Did you mean: 
HenrikS1
Contributor II
Contributor II

How to remove decimals in a pie chart

I have the below pie chart and would like to remove the decimals; where do I do that?
HenrikS1_0-1699534345069.png

 

Labels (1)
1 Solution

Accepted Solutions
MatheusC
Specialist III
Specialist III

Hi, @HenrikS1 

try this

As has already been done

1st - In the Presentation tab, remove the Percentage option and change it to value,

2° - In the expression, leave it as mentioned in the image Numeric format without decimal,


Now in the expression let:
Sum(sales)
/
sum(total sales)

3° for the values ​​to be correct, divide by the total of your measurement

I'll send a printout with the examples

 

MatheusC_0-1699540590671.png



MatheusC_1-1699540790966.png

 

Did you find a solution to your question? Mark the solution as accepted ✅ and if you found it useful, press the like button!

View solution in original post

5 Replies
HenrikS1
Contributor II
Contributor II
Author

I chose to use Share to get percentages:

HenrikS1_1-1699535534562.png


In Data I then choose to not display any decimals, it still shows one and if I choose to show two still only one is shown,

HenrikS1_0-1699535456231.png

 

MatheusC
Specialist III
Specialist III

Hi, @HenrikS1 

try this

As has already been done

1st - In the Presentation tab, remove the Percentage option and change it to value,

2° - In the expression, leave it as mentioned in the image Numeric format without decimal,


Now in the expression let:
Sum(sales)
/
sum(total sales)

3° for the values ​​to be correct, divide by the total of your measurement

I'll send a printout with the examples

 

MatheusC_0-1699540590671.png



MatheusC_1-1699540790966.png

 

Did you find a solution to your question? Mark the solution as accepted ✅ and if you found it useful, press the like button!
HenrikS1
Contributor II
Contributor II
Author

Thank you for your suggestions @MatheusC , but I am afraid I do not get what to do in the expression. Currently it looks like this:

=NUM(Count({<[delivery_:_status]={'On-going'}>}[risk_delay_eis?]),'#,###.%')

Or rather Count({<[delivery_:_status]={'On-going'}>}[risk_delay_eis?]) as I tried formatting here instead

MatheusC
Specialist III
Specialist III

@HenrikS1 

Changing the graph to value, you need to bring that representation back, so we use the total function

in your expression try this:


Count({< [delivery_:_status]={'On-going'}>}[risk_delay_eis?])
/

Count(total {< [delivery_:_status]={'On-going'}>}[risk_delay_eis?])

Did you find a solution to your question? Mark the solution as accepted ✅ and if you found it useful, press the like button!
HenrikS1
Contributor II
Contributor II
Author

Thanks again for taking the time! I was confused as in Editing mode, the chart was just empty. Only when escaping that mode did the figures show and now without decimals. Brilliant!!