Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Stacked bar with drill down groups

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

Labels (1)
1 Solution

Accepted Solutions
Not applicable
Author

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

it worked

View solution in original post

5 Replies
Kushal_Chawda

Please share sample application

prieper
Master II
Master II

What is not working?

Probably a versioning problem.

may look as fllws with QV 11.2 SR16:

Peter

Not applicable
Author

We started this project in v12 only

Not applicable
Author

it is working for pie chart

Not applicable
Author

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

it worked