3 Replies Latest reply: Sep 22, 2011 11:17 AM by Anquetil Christophe RSS

    Script : how to create table of accumulations

    Anquetil Christophe

      hi all,

      I'm new in Qlikview.

      Id to like create a Table of accumulations with data from a QVD.

       

      Original Data  :

      ItemCustomer N°PriceQtyDateYearweekMonth

      123456C13134515$82011/09/01201120113509
      321456C13134512$22011/09/13201120113709

       

      I’d like the Table of accumulations to look like this :

       

      Customer N°
      YearMonthWeekActivity
      C131345
      2011092011351
      C131345
      201109201136

      0

      C131345
      2011092011371

      etc.

       

      if sales <> 0 then Activity = 1 else Activity = 0

      Maybe, another solution exists.

       

      Is it possible in script ?


      Thank for your help

       

      Chris.