topic How to create a reference line for CAGR in Qlik Sense in App Development https://community.qlik.com/t5/App-Development/How-to-create-a-reference-line-for-CAGR-in-Qlik-Sense/m-p/870979#M12042 <HTML><HEAD></HEAD><BODY><P>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.&nbsp; 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!</P><P><BR />Sahir</P></BODY></HTML> Sat, 16 Nov 2024 11:08:36 GMT 2024-11-16T11:08:36Z How to create a reference line for CAGR in Qlik Sense https://community.qlik.com/t5/App-Development/How-to-create-a-reference-line-for-CAGR-in-Qlik-Sense/m-p/870979#M12042 <HTML><HEAD></HEAD><BODY><P>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.&nbsp; 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!</P><P><BR />Sahir</P></BODY></HTML> Sat, 16 Nov 2024 11:08:36 GMT https://community.qlik.com/t5/App-Development/How-to-create-a-reference-line-for-CAGR-in-Qlik-Sense/m-p/870979#M12042 2024-11-16T11:08:36Z Re: How to create a reference line for CAGR in Qlik Sense https://community.qlik.com/t5/App-Development/How-to-create-a-reference-line-for-CAGR-in-Qlik-Sense/m-p/870980#M12043 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Tue, 14 Jul 2015 13:46:18 GMT https://community.qlik.com/t5/App-Development/How-to-create-a-reference-line-for-CAGR-in-Qlik-Sense/m-p/870980#M12043 jonathandienst 2015-07-14T13:46:18Z Re: How to create a reference line for CAGR in Qlik Sense https://community.qlik.com/t5/App-Development/How-to-create-a-reference-line-for-CAGR-in-Qlik-Sense/m-p/870981#M12044 <HTML><HEAD></HEAD><BODY><P>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).</P><P></P><P>Kind regards,</P><P>Sahir</P></BODY></HTML> Tue, 14 Jul 2015 13:50:48 GMT https://community.qlik.com/t5/App-Development/How-to-create-a-reference-line-for-CAGR-in-Qlik-Sense/m-p/870981#M12044 2015-07-14T13:50:48Z Re: How to create a reference line for CAGR in Qlik Sense https://community.qlik.com/t5/App-Development/How-to-create-a-reference-line-for-CAGR-in-Qlik-Sense/m-p/870982#M12045 <HTML><HEAD></HEAD><BODY><P>Sorry - I get QV and Sense all together - did not notice that this was a Sense question.</P></BODY></HTML> Tue, 14 Jul 2015 13:52:31 GMT https://community.qlik.com/t5/App-Development/How-to-create-a-reference-line-for-CAGR-in-Qlik-Sense/m-p/870982#M12045 jonathandienst 2015-07-14T13:52:31Z