Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to group date according to Financial Year?

Hi,

I am finding a way to check whether a given date is fall within the financial year period. After that, I want to count on the ID of the Date where the Date is falling inside the financial year range. The FY will be my dimension in the report.

Financial Year 2012: July2011 to Jun2012

Financial Year 2013: July2012 to Jun2013

Raw Data:

ID

Date

001

14/02/2012

002

20/08/2012

003

31/03/2012

004

14/06/2012

005

22/07/2012

006

31/05/2012

After sorting:

Dimension FY

Date

FY2012

14/02/2012

31/03/2012

31/05/2012

14/06/2012

FY2013

22/07/2012

20/08/2012

Result:

Dimension FY

Count of ID

FY2012

4

FY2013

2

Thanks for your help and guides!

Regards,

SC

1 Reply
jagan
Luminary Alumni
Luminary Alumni

Hi,

Please find attached file for solution.  Hope attached file helps you.

Regards,

Jagan.