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:




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


      they bring up an error message saying:


      Can anyone suggest what i need to do?


      Many Thanks