Year field in qvw file

[#1]

Hi friends,

I have aa.qvw file which will pick the data daily from access file and every day it is getting incremental load i,e the file size is increasing day by day. And the Year is like below in aa.qvw file.

Year
2008-2009
2009-2010
2010-2011
2011-2012
2012-2013
2013-2014

Now I need to take a copy of aa.qvw file and need to rename as aa2013.qvw. and the access file contains data from July 2013 onwards. my question how can i change the Year so that I need to see as

Year
2013-2014
(2014-2015)future
(2015-2016)future

Is it possible to get like this. Could anyone tell me.

Thanks.

[#2]

do u have qlikview publisher to reload the application?

if u have then can distribute the application as per the some selection(where Yearmonth='July 2013').

Regards,

Kabilan K.

[#3]

Hi,

I don't have qlikview publisher instead only server . In this case how can I create as I have DateLogged from xx_accdb.qvd

MinMax:

LOAD

Max(TIMESTAMP(DateLogged)) AS MaxDate,
     Min(TIMESTAMP(DateLogged)) AS MinDate

FROM
[..\QVD\AccessACCDB_QVD\xx_accdb.qvd]
(qvd);