Skip to main content
Announcements
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
cliff_clayman
Creator II
Creator II

How to create a dynamic reference line in a bar chart

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?

12 Replies
cliff_clayman
Creator II
Creator II
Author

No ones knows how to answer this question?

vishsaggi
Champion III
Champion III

Can you share a sample to look into? What is the expr you are using for your reference line. May be use Axis tab for static min and static max to enter min and max values. Not sure unless i see some information.

vkish16161
Creator III
Creator III

Cliff,

Can you please share a screenshot of the reference line expression you're using?

cliff_clayman
Creator II
Creator II
Author

TargetReferenceLine.JPG

vishsaggi
Champion III
Champion III

Can you share a sample file?

cliff_clayman
Creator II
Creator II
Author

No, the file is quite large and has proprietary information in it.

Anonymous
Not applicable

You'll need to set the max axis value on the Axes tab.

I don't know your dimension or expression but it would be something like this.

=rangemax(0.10,max(aggr(ChartExpression,ChartDimension))+0.05)

vishsaggi
Champion III
Champion III

What is your expression you are using for your bar chart? As Atkinson mentioned you have to write an expr in Axes tab.

cliff_clayman
Creator II
Creator II
Author

My chart doesn't have a dimension and it has 13 different expressions.