topic Re: Trending with Line Chart in QlikView https://community.qlik.com/t5/QlikView/Trending-with-Line-Chart/m-p/825759#M290836 <HTML><HEAD></HEAD><BODY><P>Happy to write a helpful answer. <BR />Cheers <IMG src="https://community.qlik.com/legacyfs/online/emoticons/grin.png" /></P></BODY></HTML> Sun, 14 Dec 2014 10:29:10 GMT Anonymous 2014-12-14T10:29:10Z Trending with Line Chart https://community.qlik.com/t5/QlikView/Trending-with-Line-Chart/m-p/825753#M290830 <HTML><HEAD></HEAD><BODY><P>I am trying to trend a growth rate fact with a time dimension, MonthYear.&nbsp; The growth rate is calculated as:</P><P></P><P>[current month prescriptions]/[previous month prescription] - 1 and formatted as a percentage.&nbsp; To test the calculation, i have created a text object which yields the following value:</P><P></P><P><IMG alt="Screen Shot 2014-12-14 at 10.09.47.png" class="image-1 jive-image" src="/legacyfs/online/73426_Screen Shot 2014-12-14 at 10.09.47.png" style="height: auto;" /></P><P>However when i try to trend the growth rate in a line chart over the MonthYear dimension, only one point is displayed as follows:</P><P></P><P><IMG alt="Screen Shot 2014-12-14 at 10.09.34.png" class="jive-image image-2" src="/legacyfs/online/73439_Screen Shot 2014-12-14 at 10.09.34.png" style="height: auto;" /></P><P>The value displayed is for only one point which is the last MonthYear equivalent.&nbsp; Can you assist in resolving this problem.</P><P></P><P>Regards</P><P></P><P>Chris</P></BODY></HTML> Sun, 14 Dec 2014 09:01:44 GMT https://community.qlik.com/t5/QlikView/Trending-with-Line-Chart/m-p/825753#M290830 Anonymous 2014-12-14T09:01:44Z Re: Trending with Line Chart https://community.qlik.com/t5/QlikView/Trending-with-Line-Chart/m-p/825754#M290831 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Could you please post an example QlikView file?</P><P></P><P>thanks,</P><P>Rajesh Vaswani</P></BODY></HTML> Sun, 14 Dec 2014 09:41:44 GMT https://community.qlik.com/t5/QlikView/Trending-with-Line-Chart/m-p/825754#M290831 rajeshvaswani77 2014-12-14T09:41:44Z Re: Trending with Line Chart https://community.qlik.com/t5/QlikView/Trending-with-Line-Chart/m-p/825755#M290832 <HTML><HEAD></HEAD><BODY><P>Many thanks Rajesh</P><P></P><P>I have seen where the problem is.&nbsp; My expression for calculating 'Previous Month' has errors.&nbsp; I tested it out by constructing the following straight table:</P><P></P><P><IMG alt="Screen Shot 2014-12-14 at 11.57.57.png" class="image-1 jive-image" src="/legacyfs/online/73440_Screen Shot 2014-12-14 at 11.57.57.png" style="height: auto;" /></P><P>The expression for 'Current Month' is:</P><P></P><P>=Count(Distinct [Script Number])</P><P>I tried the following for previous month which is yielding the above result:</P><P>=<SPAN style="color: #0433ff;">Count</SPAN>(${&lt;Month = <SPAN style="color: #929292;"><STRONG><EM>$(=max(Month)-1)</EM></STRONG></SPAN>&gt;}Distinct<SPAN style="color: #941100;">[Script Number]</SPAN>) </P><P>Can you assist?</P><P></P><P>Regards</P><P></P><P>Chris</P></BODY></HTML> Sun, 14 Dec 2014 10:04:42 GMT https://community.qlik.com/t5/QlikView/Trending-with-Line-Chart/m-p/825755#M290832 Anonymous 2014-12-14T10:04:42Z Re: Trending with Line Chart https://community.qlik.com/t5/QlikView/Trending-with-Line-Chart/m-p/825756#M290833 <HTML><HEAD></HEAD><BODY><P>Use this :</P><P>=sum(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">prescriptions</SPAN>)/above(sum(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">prescriptions</SPAN>))-1 in the chart and you will get what you need. And of course check the percentage box</P><P>Cheers <IMG src="https://community.qlik.com/legacyfs/online/emoticons/grin.png" /></P></BODY></HTML> Sun, 14 Dec 2014 10:11:43 GMT https://community.qlik.com/t5/QlikView/Trending-with-Line-Chart/m-p/825756#M290833 Anonymous 2014-12-14T10:11:43Z Re: Trending with Line Chart https://community.qlik.com/t5/QlikView/Trending-with-Line-Chart/m-p/825757#M290834 <HTML><HEAD></HEAD><BODY><P>Managed to figure is out with the following expression for the growth rate:</P><P><SPAN style="color: #000000;">=</SPAN>count<SPAN style="color: #000000;">(</SPAN>DISTINCT<SPAN style="color: #000000;"> </SPAN><SPAN style="color: #941100;">[Script Number]</SPAN><SPAN style="color: #000000;">)/</SPAN>Above<SPAN style="color: #000000;">(</SPAN>Count<SPAN style="color: #000000;">(</SPAN>DISTINCT<SPAN style="color: #000000;"> </SPAN><SPAN style="color: #941100;">[Script Number]</SPAN><SPAN style="color: #000000;">))-1 </SPAN></P><P></P><P>with the following result:</P><P></P><P><IMG alt="Screen Shot 2014-12-14 at 12.24.02.png" class="image-1 jive-image" src="/legacyfs/online/73441_Screen Shot 2014-12-14 at 12.24.02.png" style="height: 213px; width: 620px;" /></P><P>Thank you all</P><P></P><P>Regards.</P><P></P><P>Chris</P><P><SPAN style="color: #000000;"><BR /></SPAN></P></BODY></HTML> Sun, 14 Dec 2014 10:25:01 GMT https://community.qlik.com/t5/QlikView/Trending-with-Line-Chart/m-p/825757#M290834 Anonymous 2014-12-14T10:25:01Z Re: Trending with Line Chart https://community.qlik.com/t5/QlikView/Trending-with-Line-Chart/m-p/825758#M290835 <HTML><HEAD></HEAD><BODY><P>Many thanks Utkarsh, that is the right approach, i had managed to figure it out when i got your response.</P><P></P><P>Most appreciated</P></BODY></HTML> Sun, 14 Dec 2014 10:26:31 GMT https://community.qlik.com/t5/QlikView/Trending-with-Line-Chart/m-p/825758#M290835 Anonymous 2014-12-14T10:26:31Z Re: Trending with Line Chart https://community.qlik.com/t5/QlikView/Trending-with-Line-Chart/m-p/825759#M290836 <HTML><HEAD></HEAD><BODY><P>Happy to write a helpful answer. <BR />Cheers <IMG src="https://community.qlik.com/legacyfs/online/emoticons/grin.png" /></P></BODY></HTML> Sun, 14 Dec 2014 10:29:10 GMT https://community.qlik.com/t5/QlikView/Trending-with-Line-Chart/m-p/825759#M290836 Anonymous 2014-12-14T10:29:10Z