Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ksomosera10
Creator II
Creator II

Expression to round up the Pie Chart Share

Hi,

I just want to ask how can I customize my Pie chart share so that I can make the share round up and doesn't contain decimal values. here is my Pie chart for reference.

Capture.JPG

For now my current settings is Share because it is the one that shows values in percentage. For example.the 32.1% will be 32% but will rise up to 33% when it gets to 32.5%. I hope you can help me with this. Thanks!

1 Solution

Accepted Solutions
rahulpawarb
Specialist III
Specialist III

Hello Kevin,

Trust that you are doing great!

To fix this, open chart properties and go to the Number tab. Select the expression you want to format; Select Integer & tick Show in Percent (%) check box and click OK.

Hope this will be of help.

P.S.: I have used expression as Count([Project id])/ Count(TOTAL [Project id])

Regards!

Rahul

View solution in original post

9 Replies
rbilecki
Contributor II
Contributor II

Hello, did you try use the function Round()?

prat1507
Specialist
Specialist

Use your expression as:

=NUM(Expression,'#,###.%')

Regards

Pratyush

vinieme12
Champion III
Champion III

use Round(YourExpression)

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
rahulpawarb
Specialist III
Specialist III

Hello Kevin,

Trust that you are doing great!

To fix this, open chart properties and go to the Number tab. Select the expression you want to format; Select Integer & tick Show in Percent (%) check box and click OK.

Hope this will be of help.

P.S.: I have used expression as Count([Project id])/ Count(TOTAL [Project id])

Regards!

Rahul

ishanbhatt
Creator II
Creator II

Hi Kevin,

Please Check that your Number format in Number Tab.

If Fixed To number formatting is selected then remove the decimal number from it.

Use below Expression

          =Count(Field)/100   or  Count(Field) / Count (Distinct Field)

In Number Property

   Select  Fixed To Number Format Setting Radio Button. Don't add any value in  Decimals.

    Check the Show in Percent (%) checkbox.

Employee Share Pie Chart.PNG

Please find the attached app for the example.

Hope this'll helpful to you.

ishanbhatt
Creator II
Creator II

Hi Kevin,

Please Check that your Number format in Number Tab.

If Fixed To number formatting is selected then remove the decimal number from it.

Use below Expression

          =Count(Field)/100   or  Count(Field) / Count (Total Field)

In Number Property

   Select  Fixed To Number Format Setting Radio Button. Don't add any value in  Decimals.

    Check the Show in Percent (%) checkbox.

ksomosera10
Creator II
Creator II
Author

Thanks! It solved my problem!

ajinkyabhonsle
Contributor III
Contributor III

How do we do this QlikSense. I have the same question of rounding up the %. However In my measures I have 

sum({<LANDING_PAGE_SECTION = {"*developers*"}>}SESSIONS)

deepti_singh
Creator II
Creator II

Hi Ajinkya,

In your pie chart >> in dimension write

YourDim&' : '& aggr(num(sum(YourMeasure)/sum(total{<YourDim>} YourMeasure),'#,##0.%'),YourDim)

where measure:

sum({<LANDING_PAGE_SECTION = {"*developers*"}>}SESSIONS)

In Presentation >> Value labels>> Custom select Values

Note:- This will show both share and values in the pie, but at least you can format your share in the dimension.