topic Re: Stacked bar with drill down groups in QlikView

Stacked bar with drill down groups

Wed, 25 Nov 2020 16:16:04 GMT

Hi Folks,

I have bar chart with

dim1 :month

dim2 : Rgroup(drill down)

exp1: sum(sales)

when I create a stacked bar chart it is coming up correctly, but here the problem is

when I use dimensional limits for Rgroup( drill down group ) where I wanna see top 5 and remaining as "others"

it showing blank months in chart along with proper data .

for example

month I have jan,feb,mar

jan and feb is having stacked bars ,mar value is showing in the x-aixs ,but no bar for it.

I tried with "supress null values","supress zero values","supress missing values" but no luck .

but I noticed that if I go for largest 5 and not choosing option as "others" in dimensional limits tab ,it looks good.

if I check "others " option then chart is looking Odd.

pls let me know if u require any clarification about it

Kushal_Chawda — Fri, 12 May 2017 09:27:03 GMT

Please share sample application

prieper — Fri, 12 May 2017 09:53:41 GMT

What is not working?

Probably a versioning problem.

may look as fllws with QV 11.2 SR16:

Peter

Fri, 12 May 2017 10:20:38 GMT

We started this project in v12 only

Fri, 12 May 2017 10:21:54 GMT

it is working for pie chart

Sun, 21 May 2017 14:10:00 GMT

i did for month dimension in dim limits show values greater than zero...

it worked