Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
NorrinRadd
Contributor
Contributor

Grey Area in Stacked Bar Chart

Hi all,

I have created a stacked Bar Chart and am seeing some grey areas at the top of some of the stacks. All these stacks add up to 100% so not sure as to why these are appearing. I have no null values in the dimension I am using either.

Has anyone else seen similar beviour and what was the cause?

 

NorrinRadd_1-1591094385056.png

Thanks...

1 Solution

Accepted Solutions
raghuchowdary
Contributor II
Contributor II

Hi,

In the chart properties on the Appearance Section , do you have the Scale Range set to "Auto".

If not, please set to auto this would resolve that scale issue(broken stacks).

Thank You

View solution in original post

6 Replies
fosuzuki
Partner - Specialist III
Partner - Specialist III

Are you sure that the stacks are not resulting in more than 100%? This would explain the grey areas.

I'd suggest you to export the data to excel to validade the data.

Can you post the app?

NorrinRadd
Contributor
Contributor
Author

Yeah, had actually already tried that for a single month and they add up to 100%. 

 

Interestingly these grey areas only appeared after a recent Qlik upgrade at my site.

 

Unfortuntatley can't  post the app.

 

raghuchowdary
Contributor II
Contributor II

Hi,

In the chart properties on the Appearance Section , do you have the Scale Range set to "Auto".

If not, please set to auto this would resolve that scale issue(broken stacks).

Thank You

fosuzuki
Partner - Specialist III
Partner - Specialist III

If the issue appeared after an upgrade, and you did not change any properties, it may be a bug.

Contact Qlik support and see if they can help you.

NorrinRadd
Contributor
Contributor
Author

Thanks. missed that. I had a custom setting set.

 

 

ckulp
Contributor III
Contributor III

Hi, 

In the case a user wants to set a maximum on the Y Axis Range, such as 100% if looking at proportions, is there a way to suppress the grey broken stacks? It seems to be a rounding issue in my data one value is reading over 100% that I can't seem to rectify. It would be great to remove the grey broken stack in this instance. 
Thanks,

Chris