Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
use
num(sum(value)/sum(total value)*100,'#.###')
in your expression, that will show the value in number without %
Regards
Hi
Unfortunately I don't think that works as the pie chart works as the pie chart is created from ticking 'Relative Values'
Paul
sure it works
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,'#.###')
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
thanks Martin
I didn't untick relative value, and also missed off the 'total' on the second expression
Many thanks for you help
..apologies qlik community wont allow me to 'accept as solution' to your reply