How to have 2*y axis in one diagram + areas + bars + lines

[#1]

Dear all,

I do need a diagram which looks like the one below:

...having

1. a barchart (blue bars) - no problem

2. a calculated black line - minor problem: The line should follow relative values (%) while the bars have absolute values!

3. a lower boundary-area for the black line (red)

4. an upper boundary-area for the black line (green)

5. TWO y-axis (one relative for lines/areas, one absolute for the bars).

Could anyone please help me? I did not find anything suitable in QlikView manual.

Thanks a lot

Oliver

[#2]

You need to choose proper axes settings on properties axes tab\

Firstly, you select the expression and then for the seleted expression you choose axis position (Lefr or right).

There you can also scale those axes so that the 100% suits the highest bar value.

[#3]

Thanks a lot - I had missed this option.

Now I get a diagram like this:

Is there any way to get the green line / red line appear as areas (see 3.+4. in my initial question)

Thanks Oliver

[#4]

The worst solution (and unfortunately the only i came upon) is to place 2 chart, one above the other. One only with Upper and lower bound.