topic Max YearMonth in QlikView

Max YearMonth

rido1421 — Thu, 22 Jan 2015 07:42:03 GMT

Hi There

I want to create a fiscal YearMonth field (201501)

I currently have [Fiscal Year] and [Fiscal Month] fields

I have done the below but doesnt work for me

[Fiscal Year]&[Fiscal Month] as FiscalYearMonth= 20151

when I Max(FiscalYearMonth) = 201412 ,it should be 201504 as the fiscal year starts in October.

how can I achieve this?

Your assistance is appreciated.

anbu1984 — Thu, 22 Jan 2015 07:46:23 GMT

[Fiscal Year]&Num([Fiscal Month],'00') as FiscalYearMonth

[Fiscal Year]&Right('0'&[Fiscal Month],2) as FiscalYearMonth

rido1421 — Thu, 22 Jan 2015 07:52:02 GMT

This seemed to work quite well

[Fiscal Year]*100 + [Fiscal Month] as FiscalYearmonth,

jagan — Thu, 22 Jan 2015 09:25:05 GMT

Hi,

Check this thread

Regards,

Jagan.