topic Re: Predefined segments in stacked bar chart in QlikView

Predefined segments in stacked bar chart

magertgen — Thu, 15 Oct 2015 21:12:15 GMT

Hey all, I'm looking to create a combo chart with stacked bars. I want the bar segments to be defined ranges, and have the line show the value.

So for each time period (dimension) I'd have a bar with 0-99, 100-199, 200-299, etc, with each bar showing ALL the segments. I'm sure this can be done, but I've searched and for the life of me can't an example of how to do it. (Of course, maybe it can't be done and that's why I can't find any examples.)

I've never had to do this before and it has me scratching my head. Any help would be appreciated!

Thanks in advance,

~Mark

Re: Predefined segments in stacked bar chart

magertgen — Tue, 20 Oct 2015 18:33:31 GMT

OK, I figured this out. I simply created an expression for each segment, starting with the bottom segment. Each expression is simply a number for the range of that bar segment.

For example, if you wanted five ranges:

0-200

200-400

400-500

500-600

600-1000

Your expressions would be

200

100

400

This worked great and the line segment plotted correctly in the bar segments.

~Mark