Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Navars
Contributor III
Contributor III

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
Navars
Contributor III
Contributor III
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
Patrick566
Contributor
Contributor

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

 

Omegle