topic Re: expression help in QlikView https://community.qlik.com/t5/QlikView/expression-help/m-p/1404114#M815428 <HTML><HEAD></HEAD><BODY><P>sorry, i myself not clear with the requiremen.</P><P></P><P>I Actually want to check percentage increase or decrease between each month-year.</P><P>so between each month i want to show GREEN&nbsp; color when current month is more than previous, otherwise show red color in a new column.</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 14 Sep 2017 11:12:32 GMT surajap123 2017-09-14T11:12:32Z expression help https://community.qlik.com/t5/QlikView/expression-help/m-p/1404110#M815424 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P><SPAN style="font-size: 10pt;">I have data for 4 months(Jan to Apr)</SPAN></P><P>I want to create an expression that show if Apr-2012 percentage is greater than Jan-2012. If there is no data available in Jan then take feb and so on.</P><P></P><P><SPAN style="font-size: 10pt;">eg- For Product Sub-Category- 'Office Furnishings' there is no Jan data, so pick the Feb. Similarly 'Bookcases' don't have Apr data, so pick March data.</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;"><IMG alt="image.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176341_image.png" style="height: auto;" /></SPAN></P><P></P><P>Please help!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/expression-help/m-p/1404110#M815424 surajap123 2020-11-25T16:16:04Z Re: expression help https://community.qlik.com/t5/QlikView/expression-help/m-p/1404111#M815425 <HTML><HEAD></HEAD><BODY><P>Why not these?</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/176379_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 13 Sep 2017 10:33:17 GMT https://community.qlik.com/t5/QlikView/expression-help/m-p/1404111#M815425 Anil_Babu_Samineni 2017-09-13T10:33:17Z Re: expression help https://community.qlik.com/t5/QlikView/expression-help/m-p/1404112#M815426 <HTML><HEAD></HEAD><BODY><P>Hi Suraj,</P><P></P><P>Q1) What if you have Data for Jan,Feb and April but not for March?</P><P></P><P>For Jan you want to look forward and for April you want to look backward what about the months in the middle?</P></BODY></HTML> Wed, 13 Sep 2017 10:47:35 GMT https://community.qlik.com/t5/QlikView/expression-help/m-p/1404112#M815426 vinieme12 2017-09-13T10:47:35Z Re: expression help https://community.qlik.com/t5/QlikView/expression-help/m-p/1404113#M815427 <HTML><HEAD></HEAD><BODY><P>Amazing question <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />... I was wondering the same thing</P></BODY></HTML> Wed, 13 Sep 2017 12:22:07 GMT https://community.qlik.com/t5/QlikView/expression-help/m-p/1404113#M815427 sunny_talwar 2017-09-13T12:22:07Z Re: expression help https://community.qlik.com/t5/QlikView/expression-help/m-p/1404114#M815428 <HTML><HEAD></HEAD><BODY><P>sorry, i myself not clear with the requiremen.</P><P></P><P>I Actually want to check percentage increase or decrease between each month-year.</P><P>so between each month i want to show GREEN&nbsp; color when current month is more than previous, otherwise show red color in a new column.</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 14 Sep 2017 11:12:32 GMT https://community.qlik.com/t5/QlikView/expression-help/m-p/1404114#M815428 surajap123 2017-09-14T11:12:32Z