topic Re: Expression to Return (Financial Year) in QlikView

Expression to Return (Financial Year)

alkesh_sharma — Thu, 17 Jul 2014 10:34:05 GMT

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

Re: Expression to Return (Financial Year)

alexandros17 — Thu, 17 Jul 2014 10:38:21 GMT

Try this:

=MaxString(Financial_Year)

Re: Expression to Return (Financial Year)

hic — Thu, 17 Jul 2014 10:42:42 GMT

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

Re: Expression to Return (Financial Year)

Anonymous — Thu, 17 Jul 2014 10:43:26 GMT

Hi ,

Use this

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

Re: Expression to Return (Financial Year)

tresB — Thu, 17 Jul 2014 10:46:16 GMT

Try:

=FirstSortedValue(Financial_Year, -Year)