5 Replies Latest reply: Jun 5, 2013 2:28 PM by Miguel Martorell RSS

    Help on how to add 1 to the default fiscal year created by qlikview component

      Hi,

       

      I was wondering if anyone knoew of a best approach to add 1 to the actual fiscal year created by the qlikview component.

       

      For example. Creating caelndar qith QVC setting start of month as september (9)

       

      This is how it would create the dates.

       

      Original DateFiscal Year
      8/1/20122011
      9/1/20122012
      10/1/20122012
      11/1/20122012
      12/1/20122012
      1/1/20132012
      2/1/20132012
      3/1/20132012
      4/1/20132012
      5/1/20132012
      6/1/20132012
      7/1/20132012
      8/1/20132012
      9/1/20132013

       

      The following is how I would like the scrip to create the fiscal year.

       

      Original DateFiscal Year
      8/1/20122012
      9/1/20122013
      10/1/20122013
      11/1/20122013
      12/1/20122013
      1/1/20132013
      2/1/20132013
      3/1/20132013
      4/1/20132013
      5/1/20132013
      6/1/20132013
      7/1/20132013
      8/1/20132013
      9/1/20132014

       

      Any help would be appreciated,

       

      Thanks.