Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paul_ripley
Creator III
Creator III

Pie charts - show percentage as a number without the % icon

I have a pie chart that I would like to use in NPrinting.  In qlikview the pie chart  shows for example either 45% or 0.45

I would like it to show 45.  I have tried amending the number formats but cant seem to do this

Can you please help

Paul

 

 

1 Solution

Accepted Solutions
martinpohl
Partner - Master
Partner - Master

You have to calculate

sum(
{< 
pl -={"X01*"}, Category = {"Brought Forward"}, period = {$(vStartPeriod_CY)}, bussline_abrev = {PE}
>}
[Investment GBP])

/

sum(
{< pl -={"X01*"}, Category = {"Brought Forward"}, period = {$(vStartPeriod_CY)}, bussline_abrev = {PE}
>} total [Investment GBP])

*100

View solution in original post

7 Replies
martinpohl
Partner - Master
Partner - Master

Hi,

use

num(sum(value)/sum(total value)*100,'#.###') 

in your expression, that will show the value in number without %

Regards

paul_ripley
Creator III
Creator III
Author

Hi

Unfortunately I don't think that works as the pie chart works  as the pie chart is created from ticking 'Relative Values'

 

Paul

martinpohl
Partner - Master
Partner - Master

Exp1.JPG

sure it works

paul_ripley
Creator III
Creator III
Author

it doesn't work unfortunately.  This is my expression below, unless I am doing something wrong

=Num(

sum(
{<
pl -={"X01*"}, Category = {"Brought Forward"}, period = {$(vStartPeriod_CY)}, bussline_abrev = {PE}
>}
[Investment GBP])
*100,'#.###')

martinpohl
Partner - Master
Partner - Master

You have to calculate

sum(
{< 
pl -={"X01*"}, Category = {"Brought Forward"}, period = {$(vStartPeriod_CY)}, bussline_abrev = {PE}
>}
[Investment GBP])

/

sum(
{< pl -={"X01*"}, Category = {"Brought Forward"}, period = {$(vStartPeriod_CY)}, bussline_abrev = {PE}
>} total [Investment GBP])

*100

paul_ripley
Creator III
Creator III
Author

thanks Martin

I didn't untick relative value, and also missed off the 'total' on the second expression

Many thanks for you help

paul_ripley
Creator III
Creator III
Author

..apologies qlik community wont allow me to 'accept as solution' to your reply