topic Re: Get Previous Fiscal year Monthwise Data in App Development https://community.qlik.com/t5/App-Development/Get-Previous-Fiscal-year-Monthwise-Data/m-p/1396992#M32358 <HTML><HEAD></HEAD><BODY><P>I don't have a permission to export my apps.</P><P></P><P><SPAN style="font-size: 13.3333px;">[Year Month] = 2016-06,2016-07 i have selected two months.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"> I want to compare the data for Previous year [<SPAN style="font-size: 13.3333px;">Year Month] = 2015-06,2015-07</SPAN></SPAN></P><P></P><P>This is my set expression </P><P></P><P>Count({&lt;[Year Month]= P([Year Month]) ,[Event Group]={'fdfgdffgd'}&gt;} DISTINCT EventRecord) </P><P></P><P>How can i achieve this functionality?</P></BODY></HTML> Thu, 02 Nov 2017 10:08:44 GMT selvakumara 2017-11-02T10:08:44Z Get Previous Fiscal year Monthwise Data https://community.qlik.com/t5/App-Development/Get-Previous-Fiscal-year-Monthwise-Data/m-p/1396990#M32356 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #212121; font-family: wf_segoe-ui_normal, 'Segoe UI', 'Segoe WP', Tahoma, Arial, sans-serif, serif, EmojiFont; font-size: 15px;">If a single month, or multiple months are selected</SPAN></P><P><SPAN style="color: #212121; font-family: wf_segoe-ui_normal, 'Segoe UI', 'Segoe WP', Tahoma, Arial, sans-serif, serif, EmojiFont; font-size: 15px;"><BR /></SPAN></P><UL><LI>Count events in the selected month(s) as current and count the same months in the previous FY year (if they select June FY<SPAN style="background: yellow;">16</SPAN>, July <SPAN style="color: #575757;"><STRONG style="color: #000000;">FY</STRONG></SPAN><SPAN style="color: #575757; background: lime;"><STRONG style="color: #000000;">17</STRONG></SPAN>, August FY<SPAN style="background: lime;">17</SPAN> as the current selection then for previous year show June FY<SPAN style="background: yellow;">15</SPAN>, July FY<SPAN style="background: lime;">16</SPAN> and August FY<SPAN style="background: lime;">16</SPAN></LI></UL></BODY></HTML> Thu, 02 Nov 2017 07:14:32 GMT https://community.qlik.com/t5/App-Development/Get-Previous-Fiscal-year-Monthwise-Data/m-p/1396990#M32356 selvakumara 2017-11-02T07:14:32Z Re: Get Previous Fiscal year Monthwise Data https://community.qlik.com/t5/App-Development/Get-Previous-Fiscal-year-Monthwise-Data/m-p/1396991#M32357 <HTML><HEAD></HEAD><BODY><P>Try to share a sample with representative data to work upon to help you.</P></BODY></HTML> Thu, 02 Nov 2017 07:40:39 GMT https://community.qlik.com/t5/App-Development/Get-Previous-Fiscal-year-Monthwise-Data/m-p/1396991#M32357 tresB 2017-11-02T07:40:39Z Re: Get Previous Fiscal year Monthwise Data https://community.qlik.com/t5/App-Development/Get-Previous-Fiscal-year-Monthwise-Data/m-p/1396992#M32358 <HTML><HEAD></HEAD><BODY><P>I don't have a permission to export my apps.</P><P></P><P><SPAN style="font-size: 13.3333px;">[Year Month] = 2016-06,2016-07 i have selected two months.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"> I want to compare the data for Previous year [<SPAN style="font-size: 13.3333px;">Year Month] = 2015-06,2015-07</SPAN></SPAN></P><P></P><P>This is my set expression </P><P></P><P>Count({&lt;[Year Month]= P([Year Month]) ,[Event Group]={'fdfgdffgd'}&gt;} DISTINCT EventRecord) </P><P></P><P>How can i achieve this functionality?</P></BODY></HTML> Thu, 02 Nov 2017 10:08:44 GMT https://community.qlik.com/t5/App-Development/Get-Previous-Fiscal-year-Monthwise-Data/m-p/1396992#M32358 selvakumara 2017-11-02T10:08:44Z