Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us March 10th, 7 ways modern analytics can help you take smarter action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kpradeep5610
Contributor II
Contributor II

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 .

 

Please help me.

 

 

Regards,

Pradeep K

Labels (3)
4 Replies
Taoufiq_Zarra
Master II
Master II

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") 😉
saran7de
Master
Master

What format is this? 2019012

Can you explain more?

kpradeep5610
Contributor II
Contributor II

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 

i hope this will help you.

 

 

Regards,

Pradeep K

 

H_Julian
Contributor III
Contributor III

//for example Dimension FiscalNum = '2019010'

Use the following Logic

SourceTable:

Load

*

From Source

 

Calendar_Source:

Load

FiscalNum

FiscalYear&' - '&Monthname as PeriodName

*,

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

;

Load

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)

Load *

Resident Calendar_Source;

 

Drop Table Calendar_Source;