Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Stacked bar chart don't use all data

Hi,

I have a strange issue with stacked bar chart. I have stock values from each month like this

Item     Age                    Month      Stock     Value     Lasteve

A          A.<30               201206     Stock1     10          1.6.2012

B          A.<30               201206     Stock1     12          3.6.2012

C         B.30-180           201206     Stock1     3            6.3.2012

D          C.NoEvents     201206     Stock1     5,6         

G          A.<30               201207     Stock1     5          1.7.2012

C         B.30-180           201207     Stock1     3            6.3.2012

D          C.NoEvents     201207     Stock1     5,6         

A          A.<30               201208     Stock1     44          1.8.2012

B          A.<30               201208     Stock1     54         3.8.2012

C         B.30-180           201208     Stock1     3            6.3.2012

D          C.NoEvents     201208     Stock1     5,6         

I'm trying to display stacked bar chart dimensions Month and then Age with expression Sum(Value). For some reason it won't show the last age groups sum value and not in total either but if I remove Force 0 from Axes settings then it will show it ok but the layout isn't ok because it won't show the whole bar. You can see the problem below.

Please can you help me to achive what I want.

OK layout, wrong summary (missing the H. Noevents age)

ok_layout_wrong_sum.jpg

OK Summary value, wrong layout

wrong_layout_ok_sum.jpg

1 Solution

Accepted Solutions
Not applicable

Re: Stacked bar chart don't use all data

Hey,

I had the same problem today and it took me up to 3 hours to get the solution, or let's call it a workaround:

It helped for me to sort the Legend in another way. Try not to sort from "A->Z" but from "Z->A", afterwards I got the right sums...

By the way: This is Version 11!!!! How the f**** can something like that happen?

Regards Klaus

2 Replies
Not applicable

Re: Stacked bar chart don't use all data

Hey,

I had the same problem today and it took me up to 3 hours to get the solution, or let's call it a workaround:

It helped for me to sort the Legend in another way. Try not to sort from "A->Z" but from "Z->A", afterwards I got the right sums...

By the way: This is Version 11!!!! How the f**** can something like that happen?

Regards Klaus

Not applicable

Re: Stacked bar chart don't use all data

The solution was exaclty that!!

I just changed the sort order and volá!

Thanks a million!

Community Browser