topic Re: In stocked bar chart getting miscellaneous bar in QlikView

In stocked bar chart getting miscellaneous bar

Navars — Wed, 28 Jul 2021 05:36:24 GMT

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.

Re: In stocked bar chart getting miscellaneous bar

MayilVahanan — Wed, 28 Jul 2021 08:29:35 GMT

Try like below

Re: In stocked bar chart getting miscellaneous bar

Navars — Thu, 29 Jul 2021 06:48:25 GMT

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.

Re: In stocked bar chart getting miscellaneous bar

MayilVahanan — Thu, 29 Jul 2021 09:01:23 GMT

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

Re: In stocked bar chart getting miscellaneous bar

Patrick566 — Mon, 02 Aug 2021 05:01:41 GMT

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

Omegle