5 Replies Latest reply: Oct 15, 2012 8:56 AM by Jose Tos RSS

    SUM BY GROUP

      Hi,

       

      Like a count group by category:

       

      Count({< HoraireName = {'Journée'} >} TOTAL <DateProd, ligne> PersonneID)

       

      is it possible to do a SUM?

      By exemple:

       

      QlikView3.png

       

      If a want to have the sum of HPrest for each HoraireName, Ligne and DateProd where HoraireName is not equal "Journée"

      I try this but it didn't work:

       

      SUM({< HoraireName = HoraireName-{'Journée'} >} TOTAL <DateProd, ligne> Surface)