Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Rjk
Contributor II
Contributor II

Fiscal year in Master calendar

Hi All 

please can you help with how to create fiscal year

 

like

2021/22

2022/23

2023/24

2024/24

in Master calendar

Labels (1)
1 Solution

Accepted Solutions
AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Left(Yearname([User Access Created],0,4),4)&'/'&Right(Yearname([User Access Created],0,4),2)

 

AshutoshBhumkar_0-1753699086739.png

 

View solution in original post

4 Replies
AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Hi,

Try below with Date column.

 

AshutoshBhumkar_1-1753697943234.png

Thanks,

Ashutosh

 

Rjk
Contributor II
Contributor II
Author

Hi Ashutosh

 

but i need like 2001/02 

AshutoshBhumkar
Partner - Specialist
Partner - Specialist

Left(Yearname([User Access Created],0,4),4)&'/'&Right(Yearname([User Access Created],0,4),2)

 

AshutoshBhumkar_0-1753699086739.png

 

Rjk
Contributor II
Contributor II
Author

Thanks Ashutosh