Bar length going out of axis, please help

[Qlik1_User1]

HI All,
Length of bar is going out of y axis, i am using Custom range MAX,MIN .
Please help on this.

[Or]

I'm not sure what it is you're asking. If you set a custom axis, and your values exceed that axis, this is the result. If you don't want it to happen, either switch to an Auto axis, or change the way you set your min and max values to avoid stuff getting cut off.

[MartW]

this is because you are, as you mentioned, using custom Min and Max values.

what you can do is set this on auto and Qlik will auto resolve this.

also i'm curious, what is the formula you used to calculated the min value?

[Qlik1_User1]

@Or 

Bar which is getting cut off  has value is -347.06k and y axis min value is also -347.06k.
So not getting how come bar is exceeding the yaxis, which is the issue over here.

[Or]

I'd suggest multiplying the max value by a small figure (1.01), rounding it up to the nearest thousand, or otherwise making it actually bigger than the value rather than identical to it.

[Qlik1_User1]

@Or Yes that's the alternate solution but was trying to figure out why this is happening, is this can be a bug  at Qlik?

[Or]

No idea. Having a bar reach literally the edge of the scale isn't something I've ever been concerned with - I always round my min and max values when I do this to avoid ugly-looking numbers. This could be as simple as a floating decimal point / rounding issue even if it is a "bug", so I'd suggest just cleaning up the min and max value rather than worrying about it.

[Qlik1_User1]

@Or Rounding off is also not working

Round(

RANGEMAX(
max(AGGR(sum({<reporting_year={">=$(=Max(reporting_year)-4)<=$(=Max(reporting_year))"}>}premiumchange*ExchangeRate),reporting_year)),
max(AGGR(sum(premiumchange*ExchangeRate),product_group_name)),
max(AGGR(sum({<reporting_year={">=$(=Max(reporting_year)-4)<=$(=Max(reporting_year))"}>}totalsavings*ExchangeRate),reporting_year)),
max(AGGR(sum(totalsavings*ExchangeRate),product_group_name)))*1.2

)

Output -  1.05m
expected - 1M

[Or]

Not sure why you'd expect this to be 1.05m. If it's the same data as your graph, it should be 1,068,456. You're also rounding it to the nearest whole number, whereas I would typically floor or ceiling it (as appropriate for min/max and negative/positive) to the nearest thousand.

[Qlik1_User1]

@Or Expected is 1M only but data coming as 1.05m, tried all floor, ceil nothing working in custom range MIN and MAX of combo chart, as to get this to nearest thousand, number formatting should be selected as Measure but in custom range section there is no option to select number formatting a Measure.

Can you try if its working for you, it will be a great help.