Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
post your expression
Try like this
Go to Chart Properties > Layout > uncheck > move/resize the chart to data
Hope this helps you
This is not working
=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.
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.
cann u reply for my issue avinash
@ 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
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.
could you please explain your issues with the help of snapshots??