topic Re: Get the sum for the current and previous fiscal year in KPI in QlikView https://community.qlik.com/t5/QlikView/Get-the-sum-for-the-current-and-previous-fiscal-year-in-KPI/m-p/1417457#M427992 <HTML><HEAD></HEAD><BODY><P>Thanks Anil. I found an answer <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 18 Sep 2017 12:10:57 GMT selvakumara 2017-09-18T12:10:57Z Get the sum for the current and previous fiscal year in KPI https://community.qlik.com/t5/QlikView/Get-the-sum-for-the-current-and-previous-fiscal-year-in-KPI/m-p/1417454#M427989 <HTML><HEAD></HEAD><BODY><P> I want to get the sum of count/ average of visitors for the current and previous fiscal year.</P><P></P><P>I need to display the total numbers visitors involved in KPI for the current and previous fiscal year.</P><P></P><P>Scenario . if i select year in the selection the total should be displayed for current and previous fiscal year.</P><P></P><P>The total is coming for the current fiscal year but doesn't for previous fiscal year.</P><P></P><P>How can i achieve it ?</P></BODY></HTML> Thu, 14 Sep 2017 12:18:02 GMT https://community.qlik.com/t5/QlikView/Get-the-sum-for-the-current-and-previous-fiscal-year-in-KPI/m-p/1417454#M427989 selvakumara 2017-09-14T12:18:02Z Re: Get the sum for the current and previous fiscal year in KPI https://community.qlik.com/t5/QlikView/Get-the-sum-for-the-current-and-previous-fiscal-year-in-KPI/m-p/1417455#M427990 <HTML><HEAD></HEAD><BODY><P>You can use this?</P><P></P><P><STRONG>Sum(TOTAL count)/Avg({&lt;[fiscal year] = {"&gt;=$(=Max(<SPAN style="font-size: 13.3333px;">[fiscal year]-1</SPAN>)) &lt;=$(=Max(<SPAN style="font-size: 13.3333px;">[fiscal year]</SPAN>))"}&gt;} Visitors)</STRONG></P></BODY></HTML> Thu, 14 Sep 2017 15:21:33 GMT https://community.qlik.com/t5/QlikView/Get-the-sum-for-the-current-and-previous-fiscal-year-in-KPI/m-p/1417455#M427990 Anil_Babu_Samineni 2017-09-14T15:21:33Z Re: Get the sum for the current and previous fiscal year in KPI https://community.qlik.com/t5/QlikView/Get-the-sum-for-the-current-and-previous-fiscal-year-in-KPI/m-p/1417456#M427991 <HTML><HEAD></HEAD><BODY><P>Second one </P><P><STRONG>Count({&lt;visitor = {'KPI'}, [fiscal year] = {"&gt;=$(=Max(<SPAN style="font-style: inherit; font-size: 13.3333px; font-family: inherit;">[fiscal year]-1</SPAN>)) &lt;=$(=Max(<SPAN style="font-style: inherit; font-size: 13.3333px; font-family: inherit;">[fiscal year]</SPAN>))"}&gt;} TOTAL Number)</STRONG></P></BODY></HTML> Thu, 14 Sep 2017 15:31:49 GMT https://community.qlik.com/t5/QlikView/Get-the-sum-for-the-current-and-previous-fiscal-year-in-KPI/m-p/1417456#M427991 Anil_Babu_Samineni 2017-09-14T15:31:49Z Re: Get the sum for the current and previous fiscal year in KPI https://community.qlik.com/t5/QlikView/Get-the-sum-for-the-current-and-previous-fiscal-year-in-KPI/m-p/1417457#M427992 <HTML><HEAD></HEAD><BODY><P>Thanks Anil. I found an answer <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 18 Sep 2017 12:10:57 GMT https://community.qlik.com/t5/QlikView/Get-the-sum-for-the-current-and-previous-fiscal-year-in-KPI/m-p/1417457#M427992 selvakumara 2017-09-18T12:10:57Z Re: Get the sum for the current and previous fiscal year in KPI https://community.qlik.com/t5/QlikView/Get-the-sum-for-the-current-and-previous-fiscal-year-in-KPI/m-p/1417458#M427993 <HTML><HEAD></HEAD><BODY><P>You can close this thread and mark as helpful ..</P></BODY></HTML> Mon, 18 Sep 2017 13:26:50 GMT https://community.qlik.com/t5/QlikView/Get-the-sum-for-the-current-and-previous-fiscal-year-in-KPI/m-p/1417458#M427993 Anil_Babu_Samineni 2017-09-18T13:26:50Z Re: Get the sum for the current and previous fiscal year in KPI https://community.qlik.com/t5/QlikView/Get-the-sum-for-the-current-and-previous-fiscal-year-in-KPI/m-p/1417459#M427994 <HTML><HEAD></HEAD><BODY><P>Anil have a Question</P><P></P><P>I have fiscal year. I want to extract the fiscal quarter </P><P></P><P>Eg. </P><P></P><P>Fiscal year - 2017 means , I want the quarter 2017-Q1,2017-Q2,2017-Q3,2017-Q4</P><P></P><P>In the data load editor, how can i achieve this ?</P></BODY></HTML> Wed, 20 Sep 2017 12:28:35 GMT https://community.qlik.com/t5/QlikView/Get-the-sum-for-the-current-and-previous-fiscal-year-in-KPI/m-p/1417459#M427994 selvakumara 2017-09-20T12:28:35Z Re: Get the sum for the current and previous fiscal year in KPI https://community.qlik.com/t5/QlikView/Get-the-sum-for-the-current-and-previous-fiscal-year-in-KPI/m-p/1417460#M427995 <HTML><HEAD></HEAD><BODY><P>May be create a <A href="https://community.qlik.com/qlik-blogpost/3138">Fiscal Year</A> calendar.... Also, look here</P><P><A href="https://community.qlik.com/docs/DOC-7094">Fiscal and Standard Calendar generation</A></P></BODY></HTML> Wed, 20 Sep 2017 13:28:12 GMT https://community.qlik.com/t5/QlikView/Get-the-sum-for-the-current-and-previous-fiscal-year-in-KPI/m-p/1417460#M427995 sunny_talwar 2017-09-20T13:28:12Z