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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
kulasekhar
Creator
Creator

How to create current year fiscal calendar in qlikview

Hi All,

how to create current year fiscal calendar in qlikview

I have 3 years data like:2012-2013

                                   2013-2014

                                   2014-2015

And fiscal start month is Nov.

I want to display Current year data (2014-2015)

Thanks

Kula

1 Reply
PrashantSangle

Hi,

Use YearName()

YearName(date,0,11)

Regards

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 🙂