topic Re: How to create Finacial Year Calender?????? in QlikView https://community.qlik.com/t5/QlikView/How-to-create-Finacial-Year-Calender/m-p/708086#M255078 <HTML><HEAD></HEAD><BODY><P>Can you tell expression for Current Financial Year vs Previous Financial Year expressions in Barchart?</P></BODY></HTML> Fri, 05 Sep 2014 05:53:56 GMT balasundaram 2014-09-05T05:53:56Z How to create Finacial Year Calender?????? https://community.qlik.com/t5/QlikView/How-to-create-Finacial-Year-Calender/m-p/708081#M255073 <HTML><HEAD></HEAD><BODY><P>plz give me how to create financial Year</P></BODY></HTML> Thu, 04 Sep 2014 10:26:04 GMT https://community.qlik.com/t5/QlikView/How-to-create-Finacial-Year-Calender/m-p/708081#M255073 balasundaram 2014-09-04T10:26:04Z Re: How to create Finacial Year Calender?????? https://community.qlik.com/t5/QlikView/How-to-create-Finacial-Year-Calender/m-p/708082#M255074 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>have a look at below post.</P><P><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-7094">http://community.qlik.com/docs/DOC-7094</A></P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Thu, 04 Sep 2014 10:29:30 GMT https://community.qlik.com/t5/QlikView/How-to-create-Finacial-Year-Calender/m-p/708082#M255074 ashfaq_haseeb 2014-09-04T10:29:30Z Re: How to create Finacial Year Calender?????? https://community.qlik.com/t5/QlikView/How-to-create-Finacial-Year-Calender/m-p/708083#M255075 <HTML><HEAD></HEAD><BODY><P>Please refer <A href="https://community.qlik.com/docs/DOC-6511">SIMPLE MASTER CALENDER</A></P><P>link</P><P></P><P>Vikas</P></BODY></HTML> Thu, 04 Sep 2014 10:45:39 GMT https://community.qlik.com/t5/QlikView/How-to-create-Finacial-Year-Calender/m-p/708083#M255075 vikasmahajan 2014-09-04T10:45:39Z Re: How to create Finacial Year Calender?????? https://community.qlik.com/t5/QlikView/How-to-create-Finacial-Year-Calender/m-p/708084#M255076 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Do this in you backend Script:</P><P></P><P>YearName(YourDateField,0,4)&nbsp;&nbsp; //&nbsp; Parameter 4 will start your Finacial Year from April to March.</P><P></P><P>eg. 2014-2015 Financial Year Start from</P><P></P><P>Apr2014</P><P>May2014</P><P>Jun2014</P><P>Jul2014</P><P>Aug2014</P><P>Sep2014</P><P>Oct2014</P><P>Nov2014</P><P>Dec2014</P><P>Jan2015</P><P>Feb2015</P><P>Mar2015</P><P><BR />See the Attachment.</P><P></P><P>Regards</P><P>Aviral Nag</P></BODY></HTML> Thu, 04 Sep 2014 10:48:17 GMT https://community.qlik.com/t5/QlikView/How-to-create-Finacial-Year-Calender/m-p/708084#M255076 aveeeeeee7en 2014-09-04T10:48:17Z Re: How to create Finacial Year Calender?????? https://community.qlik.com/t5/QlikView/How-to-create-Finacial-Year-Calender/m-p/708085#M255077 <HTML><HEAD></HEAD><BODY><P>get the min and max date from the fact table.</P><P></P><P>then iterate the date from min until max is met. Then transform the load as per requirement</P><P></P><P><A href="http://www.rhyous.com/2009/11/20/how-to-create-a-calendar-in-qlikview/" title="http://www.rhyous.com/2009/11/20/how-to-create-a-calendar-in-qlikview/">http://www.rhyous.com/2009/11/20/how-to-create-a-calendar-in-qlikview/</A></P></BODY></HTML> Thu, 04 Sep 2014 10:51:28 GMT https://community.qlik.com/t5/QlikView/How-to-create-Finacial-Year-Calender/m-p/708085#M255077 2014-09-04T10:51:28Z Re: How to create Finacial Year Calender?????? https://community.qlik.com/t5/QlikView/How-to-create-Finacial-Year-Calender/m-p/708086#M255078 <HTML><HEAD></HEAD><BODY><P>Can you tell expression for Current Financial Year vs Previous Financial Year expressions in Barchart?</P></BODY></HTML> Fri, 05 Sep 2014 05:53:56 GMT https://community.qlik.com/t5/QlikView/How-to-create-Finacial-Year-Calender/m-p/708086#M255078 balasundaram 2014-09-05T05:53:56Z Re: How to create Finacial Year Calender?????? https://community.qlik.com/t5/QlikView/How-to-create-Finacial-Year-Calender/m-p/708087#M255079 <HTML><HEAD></HEAD><BODY><P>=(Sum({&lt;FiscalYearQuarterStart={"&gt;=$(=Date(MAX(FiscalYearStart)))&lt;=$(=Date(MAX(FiscalYearQuarterStart)))"},FinancialYear=,FiscalQuarter=,WeekKey=&gt;}Amount)-</P><P>Sum({&lt;FiscalYearQuarterStart={"&gt;=$(=Date(ADDMONTHS(MAX(FiscalYearStart),-12)))&lt;=$(=Date(ADDMONTHS(MAX(FiscalYearQuarterStart),-12)))"},FinancialYear=,FiscalQuarter=,WeekKey=&gt;}Amount))</P></BODY></HTML> Fri, 05 Sep 2014 07:42:52 GMT https://community.qlik.com/t5/QlikView/How-to-create-Finacial-Year-Calender/m-p/708087#M255079 Anonymous 2014-09-05T07:42:52Z