How to create a dynamic reference line in a bar chart

[cliff_clayman]

I have a bar chart with a specific reference line.  The reference line represents a target or a goal of 10%.  However, when the bar chart values go below 10%, I lose the reference line.  How can I make the reference line be dynamic and still display when the values dip below the reference line value?

[Anonymous]

then you may have to do

rangemax(0.10,Expression1+0.05,Expression2+0.05,Expression3+0.05,Expression4+0.05,Expression5+0.05,Expression6+0.05,Expression7+0.05,Expression8+0.05,Expression9+0.05,Expression10+0.05,Expression11+0.05,Expression12+0.05,Expression13+0.05)

it's hard to say without seeing your app or expressions or data.

[Vasiliy_Beshentsev]

Hello, maybe you help me here Custom color in combined chart ?

[Anonymous]

I took a look at your linked question but I don't think I can help.  I work in Qlikview not Qlik Sense.  In Qlikview you can specify the color of each chart item.

Also if THIS thread is resolved please mark an answer correct.

Qlik Community Tip: Marking Replies as Correct or Helpful