Skip to main content
Announcements
Accelerate Your Success: Fuel your data and AI journey with the right services, delivered by our experts. Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik1_User1
Specialist
Specialist

Bar length going out of axis, please help

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

 

 

 

Labels (5)
1 Solution

Accepted Solutions
Qlik1_User1
Specialist
Specialist
Author

Changed the chart as a solution for now.

View solution in original post

11 Replies
Or
MVP
MVP

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
Partner - Specialist
Partner - Specialist

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
Specialist
Specialist
Author

@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
MVP
MVP

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
Specialist
Specialist
Author

@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
MVP
MVP

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
Specialist
Specialist
Author

@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
MVP
MVP

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
Specialist
Specialist
Author

@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.