topic Trend Analysis in QlikView https://community.qlik.com/t5/QlikView/Trend-Analysis/m-p/717472#M539132 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am trying to get the trend in the attached with an up arrow, down etc depending on the max month v previous month.</P><P></P><P>It has worked for me with a different metric that wasnt a percentage.&nbsp; I think my brackets are wrong but cant seem to fix it.</P><P></P><P>Any help appreciated.</P><P></P><P>Table on attached file</P><P></P><P>Rhona</P></BODY></HTML> Wed, 17 Sep 2014 08:49:20 GMT rcorcoran 2014-09-17T08:49:20Z Trend Analysis https://community.qlik.com/t5/QlikView/Trend-Analysis/m-p/717472#M539132 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I am trying to get the trend in the attached with an up arrow, down etc depending on the max month v previous month.</P><P></P><P>It has worked for me with a different metric that wasnt a percentage.&nbsp; I think my brackets are wrong but cant seem to fix it.</P><P></P><P>Any help appreciated.</P><P></P><P>Table on attached file</P><P></P><P>Rhona</P></BODY></HTML> Wed, 17 Sep 2014 08:49:20 GMT https://community.qlik.com/t5/QlikView/Trend-Analysis/m-p/717472#M539132 rcorcoran 2014-09-17T08:49:20Z Re: Trend Analysis https://community.qlik.com/t5/QlikView/Trend-Analysis/m-p/717473#M539133 <HTML><HEAD></HEAD><BODY><P>Hi Rhona,</P><P></P><P>Changed brackets in if, match and sum comparison clauses, also some brackets left in set analysis, check attachment to see if that's what you are looking for.</P></BODY></HTML> Wed, 17 Sep 2014 09:17:50 GMT https://community.qlik.com/t5/QlikView/Trend-Analysis/m-p/717473#M539133 rubenmarin 2014-09-17T09:17:50Z Re: Trend Analysis https://community.qlik.com/t5/QlikView/Trend-Analysis/m-p/717474#M539134 <HTML><HEAD></HEAD><BODY><P>Hi Ruben</P><P></P><P>Thank you so much for your time this is perfect.</P><P></P><P>Rhona</P></BODY></HTML> Wed, 17 Sep 2014 09:37:59 GMT https://community.qlik.com/t5/QlikView/Trend-Analysis/m-p/717474#M539134 rcorcoran 2014-09-17T09:37:59Z