Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Navars
Creator
Creator

In stocked bar chart getting miscellaneous bar

Hi All,

In 100% stocked bar chart im getting miscellaneous bar after 100%, i have unchecked the Include null values as well for the dimensions. how to get rid of this unwanted bars. developing this chart in Qliksense

stocked bar.JPG

Thanks in Advance.

 

Labels (2)
4 Replies
MayilVahanan

HI 

Try like below

MayilVahanan_0-1627460969561.png

 

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Navars
Creator
Creator
Author

Hi Mayil,

Thanks for your reply.

valid from month and Category are the dimensions i am using here.

Below is the expression i am using for the chart build, 

Count(distinct ID)/count(distinct total <[Valid from month]> ID)

After using Range Custom and provided Min and Max values also i am getting unwanted bars.

chart.JPG

MayilVahanan

Hi 

Is it possible to upload a sample file to verify it?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Patrick566
Contributor
Contributor

Thanks to this article I can learn more. Expand my knowledge and abilities. Actually the article is very real.

 

Omegle