topic 3 Dimension Chart in QlikView

3 Dimension Chart

timbatman — Sat, 16 Nov 2024 02:53:17 GMT

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?

Re: 3 Dimension Chart

chrismarlow — Mon, 29 Jul 2019 19:42:27 GMT

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.

Re: 3 Dimension Chart

timbatman — Mon, 29 Jul 2019 20:29:35 GMT

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?