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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to create calendar

Hi,

How to create a calendar so that i nees to see the year as

Year
2013-2014
2014-2015
2015-2016

and so on. please could anyone help me.

Thanks.

2 Replies
Not applicable
Author

Hi.

Load datefield, Year(datefield)&'-'&Year(datefield)+1 as Year from urtable;

Regards,

Kabilan K.

Not applicable
Author

Hi,

what it means and if I use like this will it take year as 2013-2014,2014-2015,2015-2016 and so on.

 

YearName

(Date,0,7) AS FiscalYear