topic Re: Fiscal Year in QlikView https://community.qlik.com/t5/QlikView/Fiscal-Year/m-p/78599#M786764 <HTML><HEAD></HEAD><BODY><P>You may want to use an ASOF table and Canonical dates. See</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2015/11/02/the-as-of-table" style="font-size: 10pt;" title="https://community.qlik.com/blogs/qlikviewdesignblog/2015/11/02/the-as-of-table">https://community.qlik.com/blogs/qlikviewdesignblog/2015/11/02/the-as-of-table</A></P><P><A href="http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date" title="http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date">Qlik Design Blog : Canonical Date | Qlik Community</A></P><P></P><P>Although I don't understand how you can use FY for INDIA to get proper results while at the same time not knowing how to use FY for INDIA to calculate results. You didn't do this calculation in your QlikView document ?</P></BODY></HTML> Fri, 23 Feb 2018 13:00:02 GMT Peter_Cammaert 2018-02-23T13:00:02Z Fiscal Year https://community.qlik.com/t5/QlikView/Fiscal-Year/m-p/78598#M786763 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>i want to calculate YTD for that i have year,month,region,kpi &amp; value field.</P><P>I have two different region INDIA &amp; US.</P><P>If i simply calculate then its shows proper value for US but not for INDIA.</P><P>If i used FY for INDIA the it will be show proper value but i am not getting where and how to used fiscal year for INDIA.</P><P></P><P>Please help me to find out.</P><P></P><P>Thanks..</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Fiscal-Year/m-p/78598#M786763 Anonymous 2020-11-25T16:16:04Z Re: Fiscal Year https://community.qlik.com/t5/QlikView/Fiscal-Year/m-p/78599#M786764 <HTML><HEAD></HEAD><BODY><P>You may want to use an ASOF table and Canonical dates. See</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2015/11/02/the-as-of-table" style="font-size: 10pt;" title="https://community.qlik.com/blogs/qlikviewdesignblog/2015/11/02/the-as-of-table">https://community.qlik.com/blogs/qlikviewdesignblog/2015/11/02/the-as-of-table</A></P><P><A href="http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date" title="http://community.qlik.com/blogs/qlikviewdesignblog/2014/02/17/canonical-date">Qlik Design Blog : Canonical Date | Qlik Community</A></P><P></P><P>Although I don't understand how you can use FY for INDIA to get proper results while at the same time not knowing how to use FY for INDIA to calculate results. You didn't do this calculation in your QlikView document ?</P></BODY></HTML> Fri, 23 Feb 2018 13:00:02 GMT https://community.qlik.com/t5/QlikView/Fiscal-Year/m-p/78599#M786764 Peter_Cammaert 2018-02-23T13:00:02Z