topic Re: How to sort the Bar chart to financial year in App Development https://community.qlik.com/t5/App-Development/How-to-sort-the-Bar-chart-to-financial-year/m-p/1226767#M23918 <HTML><HEAD></HEAD><BODY><P>There are plenty of examples here of how to correctly set up and perform fiscal period analysis using a master calendar. Search this site for master calendar and fiscal/financial periods and you should find a solution that works for you.</P></BODY></HTML> Thu, 08 Dec 2016 07:04:11 GMT jonathandienst 2016-12-08T07:04:11Z How to sort the Bar chart to financial year https://community.qlik.com/t5/App-Development/How-to-sort-the-Bar-chart-to-financial-year/m-p/1226763#M23914 <HTML><HEAD></HEAD><BODY><P>i have a bar chart with revenu and month fields,</P><P></P><P>now&nbsp; i have to show the revenue of the financial year i.e, the dimension means month should start from April and has to end on March </P><P></P><P>please suggest me a way to solve.</P><P></P><P>thanks in advance...</P></BODY></HTML> Thu, 08 Dec 2016 06:46:53 GMT https://community.qlik.com/t5/App-Development/How-to-sort-the-Bar-chart-to-financial-year/m-p/1226763#M23914 laxmanqlik 2016-12-08T06:46:53Z Re: How to sort the Bar chart to financial year https://community.qlik.com/t5/App-Development/How-to-sort-the-Bar-chart-to-financial-year/m-p/1226764#M23915 <HTML><HEAD></HEAD><BODY><P>In Sort by Expression try:</P><P></P><P>Pick(wildmatch(Month,'Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec','Jan','Feb','Mar'),</P><P>1,2,3,4,5,6,7,8,9,10,11,12)</P></BODY></HTML> Thu, 08 Dec 2016 06:51:50 GMT https://community.qlik.com/t5/App-Development/How-to-sort-the-Bar-chart-to-financial-year/m-p/1226764#M23915 shraddha_g 2016-12-08T06:51:50Z Re: How to sort the Bar chart to financial year https://community.qlik.com/t5/App-Development/How-to-sort-the-Bar-chart-to-financial-year/m-p/1226765#M23916 <HTML><HEAD></HEAD><BODY><P>thanks for the response Shraddha,</P><P></P><P>but its not working, it showing from May to march...</P></BODY></HTML> Thu, 08 Dec 2016 06:55:29 GMT https://community.qlik.com/t5/App-Development/How-to-sort-the-Bar-chart-to-financial-year/m-p/1226765#M23916 laxmanqlik 2016-12-08T06:55:29Z Re: How to sort the Bar chart to financial year https://community.qlik.com/t5/App-Development/How-to-sort-the-Bar-chart-to-financial-year/m-p/1226766#M23917 <HTML><HEAD></HEAD><BODY><P>It working at my end.</P><P>Can you share sample app?</P></BODY></HTML> Thu, 08 Dec 2016 06:59:25 GMT https://community.qlik.com/t5/App-Development/How-to-sort-the-Bar-chart-to-financial-year/m-p/1226766#M23917 shraddha_g 2016-12-08T06:59:25Z Re: How to sort the Bar chart to financial year https://community.qlik.com/t5/App-Development/How-to-sort-the-Bar-chart-to-financial-year/m-p/1226767#M23918 <HTML><HEAD></HEAD><BODY><P>There are plenty of examples here of how to correctly set up and perform fiscal period analysis using a master calendar. Search this site for master calendar and fiscal/financial periods and you should find a solution that works for you.</P></BODY></HTML> Thu, 08 Dec 2016 07:04:11 GMT https://community.qlik.com/t5/App-Development/How-to-sort-the-Bar-chart-to-financial-year/m-p/1226767#M23918 jonathandienst 2016-12-08T07:04:11Z