Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

cliff_clayman
New Contributor III

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
New Contributor III

Re: How to create a dynamic reference line in a bar chart

No ones knows how to answer this question?

vishsaggi
Esteemed Contributor III

Re: How to create a dynamic reference line in a bar chart

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
Contributor III

Re: How to create a dynamic reference line in a bar chart

Cliff,

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

cliff_clayman
New Contributor III

Re: How to create a dynamic reference line in a bar chart

TargetReferenceLine.JPG

vishsaggi
Esteemed Contributor III

Re: How to create a dynamic reference line in a bar chart

Can you share a sample file?

cliff_clayman
New Contributor III

Re: How to create a dynamic reference line in a bar chart

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

atkinsow
Valued Contributor II

Re: How to create a dynamic reference line in a bar chart

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
Esteemed Contributor III

Re: How to create a dynamic reference line in a bar chart

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
New Contributor III

Re: How to create a dynamic reference line in a bar chart

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

Community Browser