topic Pie chart Issue in QlikView

Pie chart Issue

manoranjan_d — Wed, 13 Jul 2016 09:36:50 GMT

Hi,

I m using list box billions,million, thousand

where the value is

=If(amt='Millions', 1000000,

If(amt='Thousands', 1000,

If(amt='Billion', 100000000,1)))

its assigned to the vAmt variable

now i m using the pie hart

dimension as

id_pass_fail field is used

expression as

=Num(((sum({<category={'AGRADE'}>}spend)))/vAmt, '$#,##0.0K')

now my issue is when ever i select the thousand in list my chart size is getting small, and for billions and millions the size of chart getting bigger

i want only the same size in chart when ever i select any thing from the dollar list of thousand or million or billions

Re: Pie chart Issue

sunny_talwar — Wed, 13 Jul 2016 10:07:31 GMT

Are you displaying the expression output on the chart itself? That might be causing it since the numbers need space to display, the chart resizes. May be try enlarging the chart so that it doesn't have to resize.

Re: Pie chart Issue

manoranjan_d — Wed, 13 Jul 2016 10:25:09 GMT

hi sunny,

yes, as per my requirement i m displaying the exp output on the chart, now any other solution is available for it, bcoz i m displaying it inside the text box where there are almost 4 charts.

Re: Pie chart Issue

sunny_talwar — Wed, 13 Jul 2016 10:26:49 GMT

Can you share image of what you have?