Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Greg_Oliven
Partner - Contributor III
Partner - Contributor III

100% stacked bar chart Y axis with Auto Range goes to 150%

All my values correctly total 100% for all bars, but my Y axis has extra "headroom" - it goes up to 150%.

My measure: Sum($(vActionType)) / Sum(TOTAL<State>  $(vActionType))

does yield the proper range when I turn off Auto Range and explicitly set Min->Max to 0->1.

However I have an alternate measure not formatted as a %, so I need to rely on Auto Range.

Some other things I've tried:

  • my number format is Simple, with whole number %
  • my Y axis Scale is set to Narrow (if I set it to Medium or Wide, the Y axis goes up to 200%)
  • Include null values is off for both of my dimensions; there is no Limit on the dimensions

Any thoughts?

Labels (2)
2 Replies
NhanNguyen
Contributor III
Contributor III

I think it could be resolved by setting Max or Min/Max Range. 

W4ld
Contributor II
Contributor II

Have you found a way? I have the same problem and failed to find a solution.