Number Format in Pie chart legends

[qliksus]

Hi Guys

I need to show negative values in Pie Chart so i have give the expression condition

If (  sum(val) < 0 , num( purgechar( sum(val),'-')  ,'-#,#00) , sum(val) )

so this expression is showing me the negative values in the chart correctly

But when i select the legend in the Pie chart the number in legend is not showing the negative values

the legend is showing the correct format only when i change in the Number format tab but i dont want that

bcoz whatever i select there will be applied to all the values . tell me how to fix this

Hope i am clear please tell me if i need to explain more

[Sokkorn]

Hi,

I get your point and let try this:

If(sum(val) < 0 , num(purgechar(sum(val),'-') ,'#,##0.00;(#,##0.00)') , num(sum(val),'#,##0.00;(#,##0.00)'))

OR

If (sum(val) < 0 ,purgechar(-sum(val),'-')) , -sum(val))

Regards,

Sokkorn

[qliksus]

Hi ,

Both the ways are not working the second expression cant be used bcoz  Pie cant show negative values

So in the first expression its the same what im geting . But what i am trying to say is the number format is applied

to the values shown in the Pie i.e when u select the VALUE IN DATA POINT  option in Expression tab its fine

but the same number format is not applied in the Number shown in the legend of the pie chart this legend is

taking the format from the NUMBER TAB  so how to fix this

[Sokkorn]

Hi,

Can you attached your report?

Regards,

Sokkorn

[qliksus]

Hi,

See the attached file i have explained my scenario

[Anonymous]

Interesting one. I couldn't find a solution for what you are asking.

But it did raise an other question with me ; Do you want these negative values to show in your pie the same way as the positive values (this way +30 is the same as -30)

When I use a pie charts I always leave out the negative values:

if(Sum(Field)<0, 0, Sum(Field))

But I have no idea why the '-' is not showing in your legend, looks like a bug to me ....

[#7]

yes i want to show the negative values same as the positive so i used the purgechar function to achieve this

But what is happening is If i change something in the format the legend is showing the negative value but

this legend is not showing the number format used in the expression . So how to fix this

[qliksus]

Guys any update

[qliksus]

So i am assuming this as bug