2 Replies Latest reply: Jun 25, 2014 3:06 AM by Sailee Kumawat RSS

    Need to allign days in current to previous year

      ~~ To Display on Dashboard ~~

      Current Year Actuals and Variance

      WednesdayThursdayFridaySaturdaySunday
      1/2/20131/3/20131/4/20131/5/20131/6/2013
      1/1/20141/2/20141/3/20141/4/20141/5/2014
      Actual CYActual PYVarianceActual CYActual PYVarianceActual CYActual PYVarianceActual CYActual PYVarianceActual CYActual PYVariance
      200100100.00%150200-25.00%21015040.00%20017514.29%1901758.57%

      Hello ,

       

      Above is the data that I need to display on my dashboard in the same format. Here, the first day in current month is aligned with same day in previous year.

      Not really sure how to create this in qlikview . Can someone please help ?