4 Replies Latest reply: Jan 9, 2018 11:53 PM by Jonathan Dienst RSS

    Invalid expression

    souad ouertani

      Invalid expression  *, when i put al column in group by , works but dont need put all column  , i have to calculated mesures by client ID

      CLIENT:

      LOAD ID as CLIENT_ID ,

           MMM,

           SMV,

           NBR

      FROM

      [C:\Users\90160\Desktop\portfeuille\MMM.qvd]

      (qvd);


      Score:

      load 

      CLIENT_ID,



      MMM/(MAX (MMM))*100 as MMM1,

      SMV/(MAX (SMV))*100 AS VRD1,

      NBR/(MAX (NBR))*100 AS RELATION1

      resident CLIENT

      Group BY CLIENT_ID;