I'm new to Qlikview so you'll have to bear with me on the technical side of things. I'm putting together a dashboard and for the Fiscal year calendar object I only want to show the years 2013-14, 2014-15 and 2015-16. At the moment the object is showing everything from 1899 till 2030. This is the object in question:
I am using a list box for the object with the field 'Calendar Year_Fiscal'. If you need any further info by all means let me know.
Good question. I agree it would greatly help if we know how the years getting loaded in. And also it might make sense to restrict the years in the script itself if those years are never going to be used in the application.
I tried that expression within the properties 'Expressions' tab, I changed the [Fiscal Year] to [Calendar Fiscal_Year] which is the field name in use. The displayed years must have turned into lots of characters because all it was showing in each column was '2.....' despite the columns being really wide. This is what I used: