Announcements
Applications are open for the 2024 Qlik Luminary Program. Apply by December 15 here.
cancel
Showing results for
Did you mean:
Contributor III

## Fiscal Year period

Hi ,

i have a fiscal year period field

 Fiscal Year Period 2019012 2020001

here i want to display the fiscal year period like

2019012 - 2019 - Mar

2020001 - 2020 - Aprl

like this .

Regards,

Labels (2)

• ### sunny talwar

4 Replies

can you provide more detail ? 2019012 to 2019 - Mar ?

fiscal year start at 04/ ?

2019012 year 2019 12 month and what about 0 between 2019 and 12 ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

What format is this? 2019012

Can you explain more?

Contributor III
Author

Hi

please find the below fiscal period table for current year.

 JAN -2019010 FEB -2019011 MAR -2019012 APR -2020001 MAY -2020002 JUN -2020003 JUL -2020004 AUG -2020005 SEP -2020006 OCT -2020007 NOV -2020008 DEC -2020009

here  i have the data for 3 months which is

2019012

2020001

2020002

here i want to display 2019-Mar ,2020-Aprl, 2020- May

Regards,

Contributor III

//for example Dimension FiscalNum = '2019010'

Use the following Logic

SourceTable:

*

From Source

Calendar_Source:

FiscalNum

FiscalYear&' - '&Monthname as PeriodName

*,

Monthname(Makedate(Year,Period,1)) as Monthname

;

FiscalNum,

Num(Num#(left(FiscalNum,4))) as FiscalYear

Num(Num#(right(FiscalNum,2))) as FiscalPeriod

if(Num(Num#(right(FiscalNum,2)))>=4,Num(Num#(right(FiscalNum,2)))-3,Num(Num#(right(FiscalNum,2)))+9) as Period

if(Num(Num#(right(FiscalNum,2)))<=4,Num(Num#(left(FiscalNum,4)))+1,Num(Num#(left(FiscalNum,4)))) as Year

Resident

SourceTable

Left Join (SourceTable)