Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
alkesh_sharma
Creator III
Creator III

Expression to Return (Financial Year)

Hello,

I have one field called Year and Another Called Financial_Year with Values 2014 and 2014-2015 respectively.

If I put an expression =Max(Financial_Year) its still returning me 2014, rather I want 2014-2014.

Thankyou...

1 Solution

Accepted Solutions
alexandros17
Partner - Champion III
Partner - Champion III

Try this:


=MaxString(Financial_Year)

View solution in original post

4 Replies
alexandros17
Partner - Champion III
Partner - Champion III

Try this:


=MaxString(Financial_Year)

hic
Former Employee
Former Employee

The Max() function returns a number, e.g. 2014 or 2015. It cannot return a string. However if you define your financial years as duals, you can make it return the right number. See more on Fiscal Year.

HIC

Anonymous
Not applicable

Hi ,

Use this

RIGHT(LEFT( [SFinancial Year],4),2) & '-' & RIGHT(SubField([SFinancial Year],'/',2),2) AS FinancialYear,

tresesco
MVP
MVP

Try:

=FirstSortedValue(Financial_Year, -Year)