topic Re: Values on Datapoints in a pier chart makes the chart size small in QlikView

Values on Datapoints in a pier chart makes the chart size small

Mon, 21 Oct 2013 19:33:05 GMT

Hi,

I am trying to create a pie chart and it shows up in a big size,however if i select values on data points to see the % values , the chart becomes small, i looked at all the options to make the chart larger, but nothing works out. Am i missing something?

Thanks

Re: Values on Datapoints in a pier chart makes the chart size small

Clever_Anjos — Mon, 21 Oct 2013 19:44:57 GMT

It´s the normal behavior. As a workaround you can adjust font size and restrict format to 0% (not 0.00%) and hide legend

Re: Values on Datapoints in a pier chart makes the chart size small

Mon, 21 Oct 2013 20:01:26 GMT

Hi Anjos,

Thanks for your help, but by un selecting show legend, i lose the dimension fields on the right, is there any way to get it?Because the users dont understand which color represents which fields?

Thanks

Re: Values on Datapoints in a pier chart makes the chart size small

javier_florian — Mon, 21 Oct 2013 20:06:37 GMT

You can try show top N, and group others values with 'OTHERS' like drill&down.

Re: Values on Datapoints in a pier chart makes the chart size small

Clever_Anjos — Mon, 21 Oct 2013 20:07:27 GMT

Use a dual function to format your expression

dual(

DimensionName & ' - ' & sum(value)/sum(total value),

sum(value)

)

And uncheck all formats at Number Tab

Re: Values on Datapoints in a pier chart makes the chart size small

Mon, 21 Oct 2013 20:18:12 GMT

Hi Anjos,

No change

Re: Values on Datapoints in a pier chart makes the chart size small

Mon, 21 Oct 2013 20:18:35 GMT

Hi Florian,

Sorry i didnt get you exactly, Can you explain a bit.

Thanks

Re: Values on Datapoints in a pier chart makes the chart size small

javier_florian — Mon, 21 Oct 2013 20:33:12 GMT

You can configure your graph:

And see:

Let me know if it work for you.

- Javier Florian

Re: Values on Datapoints in a pier chart makes the chart size small

Mon, 21 Oct 2013 20:51:44 GMT

Hi Florian,

Still no change, i still see the pie chart small.

Thanks

Re: Values on Datapoints in a pier chart makes the chart size small

javier_florian — Mon, 21 Oct 2013 21:04:59 GMT

Try with Shift + Ctrl... you can adjust your pie... Can you try limit character in the legend?

Re: Re: Values on Datapoints in a pier chart makes the chart size small

Clever_Anjos — Tue, 22 Oct 2013 12:34:28 GMT

That was what I was saying

Re: Values on Datapoints in a pier chart makes the chart size small

Tue, 22 Oct 2013 12:49:59 GMT

Hi Florian,

Shift+Ctrl did work.Thanks

Re: Re: Values on Datapoints in a pier chart makes the chart size small

Tue, 22 Oct 2013 12:50:37 GMT

Hi Anjois,

Dual also worked fine, but as per my requirement i am going with the way florian suggested.Thanks for your help.

Re: Re: Re: Values on Datapoints in a pier chart makes the chart size small

Wed, 23 Oct 2013 13:40:13 GMT

Hi Anjos,

My requirement changed to use dual and as i am using your example i did exactly the same but not able to achieve the end result attached is my QVW, Can you take a look at it please?

Thanks

Re: Re: Re: Values on Datapoints in a pier chart makes the chart size small

Clever_Anjos — Wed, 23 Oct 2013 15:55:14 GMT

Just a few fixes:

At Expressions tab

1) Change your expression to :

dual(

[Transaction Channel Desc] & '-' & num(sum([Gross Demand $])/sum(total [Gross Demand $]),'#,##0.00%'),

sum([Gross Demand $])

2) Uncheck "Relative"

At Number Tab

Check "Expression Default"

Re: Values on Datapoints in a pier chart makes the chart size small

Wed, 23 Oct 2013 16:04:29 GMT

hi Anjos,

I tried doing what you said now nothing shows up in the chart, it says no data to display? Can you please update the QVW i sent and forward it to me?

Thanks

Re: Re: Values on Datapoints in a pier chart makes the chart size small

Clever_Anjos — Wed, 23 Oct 2013 16:16:48 GMT

Of course,I´ve done a small reduction only to get a smaller qvw, please reload it

Re: Values on Datapoints in a pier chart makes the chart size small

Wed, 23 Oct 2013 16:22:11 GMT

Hi Anjos,

Perfect,Thanks