topic Logic help in QlikView https://community.qlik.com/t5/QlikView/Logic-help/m-p/1101361#M365339 <HTML><HEAD></HEAD><BODY><P>I have a requirement . if user selects lets say 3 month from Jan- March , the expression should compare result of the current selection with prev 3 months&nbsp; (OCT-DEC) and show up or down arrow.&nbsp; how to write and expression for this. pls help</P></BODY></HTML> Mon, 13 Jun 2016 15:36:45 GMT arusanah 2016-06-13T15:36:45Z Logic help https://community.qlik.com/t5/QlikView/Logic-help/m-p/1101361#M365339 <HTML><HEAD></HEAD><BODY><P>I have a requirement . if user selects lets say 3 month from Jan- March , the expression should compare result of the current selection with prev 3 months&nbsp; (OCT-DEC) and show up or down arrow.&nbsp; how to write and expression for this. pls help</P></BODY></HTML> Mon, 13 Jun 2016 15:36:45 GMT https://community.qlik.com/t5/QlikView/Logic-help/m-p/1101361#M365339 arusanah 2016-06-13T15:36:45Z Re: Logic help https://community.qlik.com/t5/QlikView/Logic-help/m-p/1101362#M365340 <HTML><HEAD></HEAD><BODY><P>May be like this assuming we are comparing Sum of sales:</P><P></P><P><STRONG>If(Sum(Sales)/Sum({&lt;Date = {"$(='&gt;=' &amp; Date(AddMonths(Min(Date), -3), 'DateFieldFormatHere') &amp; '&lt;=' &amp; <SPAN style="font-size: 13.3333px;">Date(AddMonths(Max(Date), -3), 'DateFieldFormatHere')</SPAN>)"}, Month, Year, Week, MonthYear&gt;}Sales) &gt; 1, 'Sales Increased', 'Sales Decreased')</STRONG></P></BODY></HTML> Mon, 13 Jun 2016 15:40:33 GMT https://community.qlik.com/t5/QlikView/Logic-help/m-p/1101362#M365340 sunny_talwar 2016-06-13T15:40:33Z