9 Replies Latest reply: Oct 5, 2013 6:35 PM by Steve Dark RSS

    year to date current year and last year / same period last year

    Peter Moyaert

      In my Qlikview table users need to select

      * year

      * month

       

      If for example the user selects year 2013 and month October I want to get following information

       

      - Sales current month : 01/10/2013-04/10/2013

      - Sales same period Last Year : 01/10/2012-04/10/2012

      - Sales current year YTD : 01/01/2013-04/10/2013

      - Sales same peiode YTD LY : 01/01/2012-04/10/2012

       

      And above this, I want to have a header for each colomn, stipulating the period :

       

      - Sales 04/10/2013 month

      - Sales 04/10/2012 month

      - Sales 04/10/2013 YTD

      - Sales 04/10/2012 YTD

       

      Can someone help me with both the formulas and headers ?

      Thanks a lot for your feedback.