Discussion Board for collaboration on QlikView Layout & Visualizations.
Whilst layering transparent charts is possible it tends to get very confusing very quickly - and sometimes the lining up fails.
You could use a combo chart and put a symbol above the bars to show the total (you would need to use the TOTAL <Dim> syntax to ignore the second dimension). Another way to achieve similar may be to have a stacked bar, where you have the DimValue as one expression then the Total (using TOTAL again) less the dimension value as expression two then stack them. I'm not sure whether stacked bars and multi dimensions play nicely together though.
It's always worth trying to push back to the end user to get them to have something a bit more standard, if you can.
Load * Inline
Month, Product, Sales
Jan, A, 200
Jan, B, 300
Jan, C, 120
Feb, A, 420
Feb, B, 360
Feb, C, 220
Mar, A, 180
Mar, B, 300
Mar, C, 420
Apr, A, 600
Apr, B, 400
Apr, C, 220
Create a bar cahrt with Month and Product as Dimension
In expression create two expressions
2. (TOTAL <Month> Sales)-sum(Sales)
for expression 1. background color
If(Product = 'A', Green(),
If(Product = 'B', Blue(),
If(Product = 'C', Red())))
In the color tab keep first three colors as light grey..