Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

selvakumara
New Contributor III

Get Previous Fiscal year Monthwise Data

If a single month, or multiple months are selected


  • Count events in the selected month(s) as current and count the same months in the previous FY year (if they select June FY16, July FY17, August FY17 as the current selection then for previous year show June FY15, July FY16 and August FY16
2 Replies
MVP
MVP

Re: Get Previous Fiscal year Monthwise Data

Try to share a sample with representative data to work upon to help you.

selvakumara
New Contributor III

Re: Get Previous Fiscal year Monthwise Data

I don't have a permission to export my apps.

[Year Month] = 2016-06,2016-07 i have selected two months.


I want to compare the data for Previous year [Year Month] = 2015-06,2015-07

This is my set expression

Count({<[Year Month]= P([Year Month]) ,[Event Group]={'fdfgdffgd'}>} DISTINCT EventRecord)

How can i achieve this functionality?

Community Browser