2 Replies Latest reply: May 3, 2013 6:41 AM by Anushree Gore RSS

    Aagregation in QV script

      Hello, I am trying to Load below Summary table in QV but it is showing error as Invalid Expression ...


      Summary: Load Queue as Q,

      SubCategory as S,

      Month as M,

      Week as W,

      If(RAG_Status='R',count(RAG_Status)) as R,

      If(RAG_Status='A',count(RAG_Status))as  A,

      If(RAG_Status='G',count(RAG_Status))as G

      Resident L2_Data group by Queue,SubCategory,Month,Week;



      The RAG Status column has 3 values R A and G. Please suggest me the correct syntax.