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!
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.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
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).
