Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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?