topic Re: piec chart issue in QlikView

piec chart issue

manoranjan_d — Wed, 24 Aug 2016 12:20:22 GMT

Hi all,

My chart size varying according the selection of my list box of( Billions, Millions, Thousand and whole) dollar units, how to make the pie chart size always constant, when i select the dollar units

Re: piec chart issue

arulsettu — Wed, 24 Aug 2016 12:28:05 GMT

post your expression

Re: piec chart issue

avinashelite — Wed, 24 Aug 2016 12:29:21 GMT

Try like this

Go to Chart Properties > Layout > uncheck > move/resize the chart to data

Hope this helps you

Re: piec chart issue

manoranjan_d — Wed, 24 Aug 2016 13:08:10 GMT

This is not working

Re: piec chart issue

manoranjan_d — Wed, 24 Aug 2016 13:11:25 GMT

=Num(sum(AMT))/vAmtDenominator, '$#,##0')

where vAmtDenominator is variable and assignedf with below values

=If(UNIT='Millions', 1000000,

If(UNIT='Thousands', 1000,

If(UNIT='Billion', 100000000,

if(UNIT='Whole', 1))))

unit is a list box.

Re: piec chart issue

Or — Wed, 24 Aug 2016 13:31:21 GMT

Uncheck the "Legend" and "Label" checkbox under "Dimension" (or disable the legend from Presentation). If you are otherwise displaying values in your chart or legend, remove the value display (should be under Expression or Presentation). QlikView will automatically adjust the chart size to the available size after displaying the required information in the legend and labels, so your problem is likely related to that.

You should also be able to manually set the legend size - CTRL+SHIFT and resize the red legend box - but this approach is not recommended because it may cut off your legend and make it impossible to read.

Re: piec chart issue

manoranjan_d — Wed, 24 Aug 2016 13:37:29 GMT

cann u reply for my issue avinash

Re: piec chart issue

manoranjan_d — Wed, 24 Aug 2016 13:40:09 GMT

@ shoham, My question is when ever i select the unit in list box the size of circle is varying for the thousand, millions, billions and whole, what ever i select that the size of the pie chart inside circle shd be same.

I tried all the ways u said before psoting in community, and i finally came to community. so pls help me on this

Re: piec chart issue

Or — Wed, 24 Aug 2016 13:43:28 GMT

I'm trying to help you, which is difficult considering you haven't posted a sample so we can see what the problem is, by suggesting the most common issues that might be causing your problem. Unless you post a sample, and detailed information of what you've already tried, it's difficult for anyone to help you except through guesswork.

Re: piec chart issue

avinashelite — Wed, 24 Aug 2016 15:16:24 GMT

could you please explain your issues with the help of snapshots??