topic Re: Stacked Bar Chart / Show All Values Inside Segments in QlikView

Stacked Bar Chart / Show All Values Inside Segments

lylererger — Fri, 09 Feb 2018 22:15:35 GMT

Hi frieds!

I've got a big problem.

Customers are very demanding on the visualization of their performance. The main requirement is to display values in all segments of the histogram. By default in QlikView values are not displayed in all segments, it depends on size of segment.

To meet the business requirements of visualization, I drew a chart of 3 charts. The result is a chart below.

Cool - But when I set the filter the previous Year - it turns out the gap and the whole concept collapses

Is that possible at all? Any ideas?

Please help me to draw 1 chart so that all values are displayed inside segments.

Thanks in Advance.

Re: Stacked Bar Chart / Show All Values Inside Segments

swuehl — Fri, 09 Feb 2018 22:28:22 GMT

I don't think it's possible to achieve what your customers demand (to draw the value inside segments, no matter how small the segment is).

Not sure how you've done your current solution, what do you mean with 'a chart of 3 charts'?

Would you mind uploading a small sample QVW?

Re: Stacked Bar Chart / Show All Values Inside Segments

jwjackso — Fri, 09 Feb 2018 22:33:47 GMT

First, have you selected the "Values on Data Points" for each of the expressions? In the example you show, there are 6 categories. In the Chart, you would have 6 expressions. sum(cat1)/sum(all categories), sum(cat2)/sum(all categories)...