Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

How to create a reference line for CAGR in Qlik Sense

Hi does anybody have an example for the expression when making a reference line or trend line for CAGR using a bar chart? I can't find any matching examples.  I know how to write the CAGR expression but not how to make a refrence line. My dimension is date and my measure is sum(sales). Many thanks!


Sahir

3 Replies
MVP
MVP

Re: How to create a reference line for CAGR in Qlik Sense

Go to Chart Properties | Presentation. Next to the box titled Reference Lines click Add..., add the expression and an optional label. Select Primary Y if using only a single Y axis or using the left axis.

Not applicable

Re: How to create a reference line for CAGR in Qlik Sense

Thanks, I think you are referring to qlikview? I am using Sense it is a bit different, but also I need to understand how an reference line expression works, because just using the same expression as the measure does not work (which I thought it would).

Kind regards,

Sahir

MVP
MVP

Re: How to create a reference line for CAGR in Qlik Sense

Sorry - I get QV and Sense all together - did not notice that this was a Sense question.