3 Dimension Chart

[timbatman]

Please see sample data below:

Well Number      Category      Actual Comp Cost      Actual Water Cost      Budget Comp Cost      Budget Water Cost

1                               Historic            $                                        $                                           $                                      $

2                             Forecast           $                                         $                                            $                                    $

I want a stacked bar chart with three columns:

1.  Stacked bar of actual comp cost and actual water cost for historic rows only

2.  Stacked bar of actual comp cost and actual water cost for forecast rows only

3.  Stacked bar of budget comp cost and budget water comp cost for all rows

I have been able to accomplish the first two by using a conditional format for the background color, but I am unable to get the third column in there.  I think it may be too many dimensions.  Any ideas?

[chrismarlow]

Hi,

I think you would need to tinker with the below to get some sensible dimension/measure names, but you could use ValueList dimensions;

And then reference in the expression;

There may be a less fiddly way of doing it though.

Cheers,

Chris.

[timbatman]

Yeah that is mostly what I have been playing around with.  If I wanted to add a 3rd dimension (year), would that be too many layers for Qlikview to show on a graph?