topic Re: Merge Results of Dimensions in If Statement in App Development https://community.qlik.com/t5/App-Development/Merge-Results-of-Dimensions-in-If-Statement/m-p/1362910#M30637 <HTML><HEAD></HEAD><BODY><P>Thank you. Did you get some answer for me?</P></BODY></HTML> Wed, 09 Aug 2017 19:43:58 GMT Anonymous 2017-08-09T19:43:58Z Merge Results of Dimensions in If Statement https://community.qlik.com/t5/App-Development/Merge-Results-of-Dimensions-in-If-Statement/m-p/1362909#M30636 <HTML><HEAD></HEAD><BODY><P>I would like to show the whole FY17TD(should include Jul2017)</P><P>But would also like to show Current Month JUL2017.</P><P></P><P>My script excluded July ,</P><P>How can I have it add JULY TO FY17TD?</P><P></P><P>if(</P><P>match([LATEST_START_DATE.Calendar.YearMonth],'2016/Oct', '2016/Nov','2016/Dec','2017/Jan', '2017/Feb', '2017/Mar', '2017/Apr', '2017/May', '2017/Jun', '2017/Jul', '2017/Aug', '2017/Sep')</P><P>,'FY17TD',</P><P>if(</P><P>[LATEST_START_DATE.Calendar.YearMonth] = '2017/Jul', 'Month', 'FY17TD'</P><P> )</P><P>)</P><P></P><P>I am presenting 20 DIFFERENT KPIs on my PIVOT Table and I need the two Categories!</P></BODY></HTML> Mon, 07 Aug 2017 20:52:37 GMT https://community.qlik.com/t5/App-Development/Merge-Results-of-Dimensions-in-If-Statement/m-p/1362909#M30636 Anonymous 2017-08-07T20:52:37Z Re: Merge Results of Dimensions in If Statement https://community.qlik.com/t5/App-Development/Merge-Results-of-Dimensions-in-If-Statement/m-p/1362910#M30637 <HTML><HEAD></HEAD><BODY><P>Thank you. Did you get some answer for me?</P></BODY></HTML> Wed, 09 Aug 2017 19:43:58 GMT https://community.qlik.com/t5/App-Development/Merge-Results-of-Dimensions-in-If-Statement/m-p/1362910#M30637 Anonymous 2017-08-09T19:43:58Z