topic Text in pie chart in QlikView

Text in pie chart

Wed, 23 Sep 2009 17:52:28 GMT

Hi,

I have plotted a pie chart i have taken cost in the expression and location in dimension.I need to display the total cost at the bottom of the pie chart.how do i do that?i tried with the help of text box.but i am not able to increase the size of the text area.Also i need the displayn in the following format:

Total cost =...........MillionDollars.

How can i format the cost and convert it to millions.

Please help.

Thanks in advance.

Text in pie chart

Wed, 23 Sep 2009 19:25:48 GMT

Hi,

You can use following in the textbox:-

='Total Cost = ' & your_expression & ' Million Dollars'

Here your_expression represents the expression that you are using for calculating total cost. If you want to convert it into million then just divide by 1000000 and you should get the result.

you can also use text in chart option on the presention tab instead of a textbox to plot text inside a chart.

Thanks & Best Regards,

Kuldeep Tak

Text in pie chart

Wed, 23 Sep 2009 19:29:53 GMT

Hi,

and here are an example to play with.

Good luck!

Rainer

Text in pie chart

Wed, 23 Sep 2009 19:33:52 GMT

Thank you

Text in pie chart

Wed, 23 Sep 2009 21:20:17 GMT

hi,

thanks i got the text.But the size of the text inside the chart is very long and it is getting truncated.How do i format iy?also i can keep text inside chart only on the top.how do i get it at the bottom?

Text in pie chart

Tue, 31 Jan 2012 13:50:47 GMT

Hi,

Why dont you try the "Text in Chart" under the Presentation Tab.

Then you can try ='Total Cost = ' & your_expression & ' Million Dollars'

You can enter the expression in a new line like a normal text box.

Then if you want to adjust the size of the text, hold the Ctrl + Shift key and resize as you want.

Try this and let me know if this works.

Thanks,

Robinson