In stocked bar chart getting miscellaneous bar

[Navars]

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

Thanks in Advance.

[MayilVahanan]

HI 

Try like below

[Navars]

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.

 

[MayilVahanan]

Hi 

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

[Patrick566]

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

Omegle