Solved

[microwin88x]

Solved

[sunny_talwar]

May be this:

Table:

LOAD [Fiscal Year],

     Max(Month_Year_Calendar) as Month_Year_Calendar,

     FirstSortedValue(Quantity, -Month_Year_Calendar) as Quantity

FROM

[https://community.qlik.com/thread/213623]

(html, codepage is 1252, embedded labels, table is @1)

Group By [Fiscal Year];

[swuehl]

If your Month_Year_Calendar field is a calendar field with numeric representation (and assuming a chart solution);

Chart with dimension Fiscal Year and two expressions:

=Date(Max(Month_Year_Calendar),'MMM-YY')

=FirstSortedValue(Quantitiy, -Month_Year_Calendar)

[Note that there is a discrepancy between your Fiscal year values and the year in Month_Year_Calendar?]

[sunny_talwar]

For your sample:

Table:

LOAD [Fiscal Year],

    Date(Max(Date#(Month_Year_Calendar, 'MMM-YY')), 'MMM-YY') as Month_Year_Calendar,

    FirstSortedValue(Quantity, -Date#(Month_Year_Calendar, 'MMM-YY')) as Quantity

FROM

[https://community.qlik.com/thread/213623]

(html, codepage is 1252, embedded labels, table is @1)

Group By [Fiscal Year];

[Peter_Cammaert]

Maybe tune this a bit into:

MaxTable:

LOAD [Fiscal Year],

     Max(Month_Year_Calendar) AS MaxCalendarMonth,

     FirstSortedValue(Quantity, -Month_Year_Calendar) AS MaxCalendarMonthQuantity

RESIDENT YourInputTable

GROUP BY [Fiscal Year];

Best,

Peter

[Peter_Cammaert]

Fiscal Year is most often the year of the last calendar period in the fiscal year.

Fiscal years can vary in length (now its 18 periods, after it's just 10 etc.)

Fiscal years don't have to align with calendar years.

Or what discrepancy do you mean?

Peter

[swuehl]

Right, needs to get my eyes checked, I've misread some values in the second column (or need a bigger screen).