2 Replies Latest reply: Nov 6, 2012 6:14 AM by Aushik.Makdoom RSS

    Reporting sales for a date and sales for past 3 days from that date as a continuous trend in a chart

      DateSalesSales in past 3 daysSales from 6-4 days in pastin pastSales from 9-7 days in past
      01.09.201210

      10

      0

      0
      02.09.201251500
      03.09.2012

      6

      2100
      04.09.2012102110 0
      05.09.2012723

      15

      0
      06.09.2012421210
      07.09.201221321 (from 04.09.2012 to 06.09.2012)10 (from 01.09.2012 to 03.09.2012)
      08.09.2012172315
      09.09.2012362121
      10.09.2012591321
      11.09.2012816723
      12.09.2012922621
      13.09.2012724913
      14.09.20121026167
      15.09.2012522226

      Sample Data

      The first two columns represent the actual data sample and the entire table ablove is the expected output in qlikview. Pleas help to achieve this output in Qlikview with set analysis or any other implementation