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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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