2 Replies Latest reply: Apr 23, 2017 7:45 AM by Steve Newman RSS

    Predicting sales for upcoming months

    naveen kumar

      hi,this requirement is in Qliksense

      if i got three month of sales for a particular item so how can i predict  avg  sales for the remaining and upcoming months i mean for Apr,May,June ........Dec  for each item

       

      Item       month             sales

       

      A             Jan                 1000

      A              Feb                 500

      A              Mar                 1500

      B              Jan                 2000

      B             Feb                    0

      B              Mar                 1000

       

      month(i have value till dec)

      Jan

      Feb

      Mar

      Apr

      May

      June

      .

      .

      .till

      Dec

       

       

      in Qliksense i took

      bar chart or combo chart

      Dimension : month

      Expression

       

      1)sum(sales)

      2)What Kind of Expression should i need to write to get avg line or bar for rest of months

       

       

       

       

      thanks

      naveen