Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
GeorgePhilips2302
Contributor II
Contributor II
‎2023-01-25 12:15 AM

Formula to create field with years like 2019-2020

Hi, 

Can someone frame a formula for financial years(ex. 2019-2020,2020-2021,etc.) with months starting from 1st Apr ending on 31st Mar.

Labels (1)
Labels
251 Views
0 Likes
1 Solution

Accepted Solutions
PrashantSangle
MVP
MVP
‎2023-01-25 12:31 AM

Hi,

 

use YearName(Today(),0,4)

Regards,

Prashant Sangle

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

245 Views
0 Likes
2 Replies
PrashantSangle
MVP
MVP
‎2023-01-25 12:31 AM

Hi,

 

use YearName(Today(),0,4)

Regards,

Prashant Sangle

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
246 Views
0 Likes
GeorgePhilips2302
Contributor II
Contributor II
‎2023-01-25 12:45 AM
Author

In response to PrashantSangle

Thank you bud!

240 Views
0 Likes