topic Re: How to show values beside legend in pie chart? in QlikView

How to show values beside legend in pie chart?

Fri, 15 May 2015 14:00:41 GMT

Hi,

I have dimension and expressions as below in pie chart.

Dimension1: =If(Match([ConsultName],'XX'),[ConsultName])
Dimension2: Status

Expression1: =Sum(Time_in)
Expression2: =Num(Sum(Time_in)/Sum(Total Time_in),'#,##0.00%')

the pie chart is showing percentages in value ate data points. I need the percentage values to display besdie Status legend as well. The Status have values Enter , Leave

Please can anyone suggest me how to set this.

Thanks.

Re: How to show values beside legend in pie chart?

Clever_Anjos — Fri, 15 May 2015 14:06:17 GMT

Amelia, something like this?

You can download this sample at: http://www.clever.com.br/downloads/Exemplo%20de%20dual%20para%20exibir%20rotulos.qvw

Re: How to show values beside legend in pie chart?

Fri, 15 May 2015 14:07:30 GMT

You try doing this.

presentation TAB-->Check show numbers in legend

Re: How to show values beside legend in pie chart?

sunny_talwar — Fri, 15 May 2015 14:07:35 GMT

You want to see % in legend? Try checking this option on Presentation tab:

HTH

Best,

Sunny

Re: How to show values beside legend in pie chart?

Fri, 15 May 2015 14:15:17 GMT

Thanks. I have used this. but still not showing. is there anything am I missing to check/uncheck boxes?

Re: How to show values beside legend in pie chart?

Fri, 15 May 2015 14:15:24 GMT

Thanks. I have used this. but still not showing. is there anything am I missing to check/uncheck boxes?

Re: How to show values beside legend in pie chart?

sunny_talwar — Fri, 15 May 2015 14:18:54 GMT

Try pressing ctrl + shift to check if the legend box is big enough to show you the numbers.

Stretch the red line to extend the box for legend.

HTH

Best,

Sunny

Re: How to show values beside legend in pie chart?

Fri, 15 May 2015 14:22:26 GMT

Thanks. I have tried this as well before. still not showing.

Re: How to show values beside legend in pie chart?

sunny_talwar — Fri, 15 May 2015 14:23:16 GMT

Hahahaha then the last resort for you would be to share your application or a sample

Re: How to show values beside legend in pie chart?

Fri, 15 May 2015 14:28:53 GMT

One more think,

Go to the Dimensions TAB and ensure that show legend is checked.

Re: How to show values beside legend in pie chart?

cesaraccardi — Fri, 15 May 2015 14:35:54 GMT

Hi Amelia,

I think you can achieve that by using a dual expression instead of two:

dual(num(sum(Metric)/sum(total Metric),'#,##0.0%'),sum(Metric))

Then you untick the "Relative" checkbox and tick "Show Numbers in Legend", this way it will display the numeric values on the legend and the percentages on the data points.

Hope this helps,

Cesar

Re: How to show values beside legend in pie chart?

Fri, 15 May 2015 14:42:02 GMT

The issue is that Amelia can not get the Legends to show. I think it is worth checking as mentioned before that the show legend in the dimension tab is checked

Re: How to show values beside legend in pie chart?

Fri, 15 May 2015 14:44:56 GMT

Please see attached.

Re: How to show values beside legend in pie chart?

Fri, 15 May 2015 14:45:48 GMT

Thanks. I have tried this. still not showing.

Re: How to show values beside legend in pie chart?

Fri, 15 May 2015 14:49:35 GMT

Can you please take a screen shot of your dimension TAB and presentation TAB. of course if possible.

Re: How to show values beside legend in pie chart?

Fri, 15 May 2015 14:54:10 GMT

yes.

Re: How to show values beside legend in pie chart?

sunny_talwar — Fri, 15 May 2015 14:56:17 GMT

Not sure why it is not showing the value for the second dimension. I have used text in chart as a workaround. See if thie helps.

Re: How to show values beside legend in pie chart?

buzzy996 — Fri, 15 May 2015 15:07:22 GMT

the problem with ur calculated dimension it seems.

Re: How to show values beside legend in pie chart?

Fri, 15 May 2015 15:11:04 GMT

Could it then be a problem with your Dimension Expression

If(Match([ConsultName],'XX'),[ConsultName])

may be define the else part ie

If(Match([ConsultName],'XX'),[ConsultName],'Unknow') just a test.

Re: How to show values beside legend in pie chart?

Fri, 15 May 2015 15:38:14 GMT

Thanks. when I used this it is showing 100% for both Enter and Leave instead of individual percentages. is there any reason why it is showing like this?