4 Replies Latest reply: Oct 30, 2014 7:19 AM by Ashfaq Mohammed RSS

    Sum and Group by

      Hi,

      I am very new in Qlikview development.

       

      I am trying to do a 'Group by' based on [sales year] and [sales month] to find the monthly Sales of each customer in Script.

      But I am getting 'Invalid expression' error on following script.

       

      CustomerMonthlySales:

      LOAD

      [Customer Number],

      [VE Posting Year] AS SalesYear,

      [VE Posting Month] AS SalesMonth,

      SUM([Sales Amount (Actual)]) AS MonthlySales

      Resident Fact Group BY [VE Posting Year],[VE Posting Month]