background color in chart

[#1]

Hi ,

Can I create the chart like below in qlikview

In above chart , above, below and average should be in different color and it should be dynamic i.e values of above average and below can be changed

[Anonymous]

I do not think you can.

[Gysbert_Wassenaar]

Create a combi chart with year as dimension and with four expressions. One for the line and the other three as segments of a stacked bar.

Below: =ValueOfBelow

Average: =ValueOfAverage - ValueOfBelow

Above: =ValueOfAbove - ValueOfAverage - ValueOfBelow

Select Stacked as Subtype on the Style tab

Set the Cluster Distance on the Presentation tab to 0.

Click on the + in front of the expression on the Expressions tab, select Background Color and enter a color expression in the Definition field like for example color(1) or red()

If you want users to be able to change the values for Above, Average and Below then use variables for the values and give users the option to change them with for example input boxes or sliders.

[#4]

Hi Gysbert,

can you please share the QVW file?

[vinieme12]

sample for reference, per gysbert's solutions

[Anil_Babu_Samineni]

Yes it's possible.

Recently same situation I created for bubble chart. But, if those expression should be different.

Can you please let me know your dimension and expressions or else please share me he sample application