2 Replies Latest reply: Nov 29, 2012 7:37 AM by Gysbert Wassenaar RSS

    How do I create a Financial Year dimension from date?

      Hi All,

       

      I'm new to Qlikview & this is my 1st post.

       

      I have a database link set up into my qlikview file, & I want to be able to view the data by Financial Year (Apr-Mar), I can't get any of the previous post replies on similar queries to work on my data.

       

      This is an extract from my script:

       

      QV.bmp

       

      I've tried adding both of the following commands into the script seperately, but neither worked:

      qv2.bmp

      they bring up an error message saying:

      qv3.bmp

      Can anyone suggest what i need to do?

       

      Many Thanks