topic Re: Number Format in Pie chart legends in QlikView

Number Format in Pie chart legends

qliksus — Mon, 14 Nov 2011 05:06:19 GMT

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

Number Format in Pie chart legends

Sokkorn — Mon, 14 Nov 2011 06:33:30 GMT

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)'))

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

Regards,

Sokkorn

Number Format in Pie chart legends

qliksus — Mon, 14 Nov 2011 08:20:49 GMT

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

Number Format in Pie chart legends

Sokkorn — Mon, 14 Nov 2011 08:23:06 GMT

Hi,

Can you attached your report?

Regards,

Sokkorn

Re: Number Format in Pie chart legends

qliksus — Mon, 14 Nov 2011 09:36:53 GMT

Hi,

See the attached file i have explained my scenario

Number Format in Pie chart legends

Anonymous — Mon, 14 Nov 2011 11:55:33 GMT

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 ....

Re: Number Format in Pie chart legends

Mon, 14 Nov 2011 15:30:23 GMT

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

Re: Number Format in Pie chart legends

qliksus — Tue, 15 Nov 2011 02:33:21 GMT

Guys any update

Re: Number Format in Pie chart legends

qliksus — Wed, 16 Nov 2011 02:22:54 GMT

So i am assuming this as bug