Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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
MVP
MVP

Re: How to group date according to Financial Year?

Hi,

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

Regards,

Jagan.

Community Browser