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

How to create a dynamic reference line in a bar chart

cliff_clayman — Tue, 07 Nov 2017 16:08:39 GMT

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?

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

cliff_clayman — Wed, 15 Nov 2017 17:41:04 GMT

No ones knows how to answer this question?

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

vishsaggi — Wed, 15 Nov 2017 17:45:38 GMT

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.

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

vkish16161 — Wed, 15 Nov 2017 17:46:15 GMT

Cliff,

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

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

cliff_clayman — Wed, 15 Nov 2017 17:48:34 GMT

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

vishsaggi — Wed, 15 Nov 2017 17:54:59 GMT

Can you share a sample file?

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

cliff_clayman — Wed, 15 Nov 2017 17:56:17 GMT

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

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

Anonymous — Wed, 15 Nov 2017 17:57:44 GMT

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)

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

vishsaggi — Wed, 15 Nov 2017 18:02:11 GMT

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

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

cliff_clayman — Wed, 15 Nov 2017 18:07:50 GMT

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

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

Anonymous — Wed, 15 Nov 2017 18:47:34 GMT

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.

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

Vasiliy_Beshentsev — Wed, 31 Jan 2018 13:50:26 GMT

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

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

Anonymous — Wed, 31 Jan 2018 15:19:42 GMT

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