6 Replies Latest reply: Sep 30, 2014 10:22 AM by Agis Kalogiannis RSS

    Sum by Expression in Chart

      Hi All,

       

      I'm in QlikView 11 and I want to display the sum of one column of data in a table chart, but am having trouble with the expression.

       

      Here's a sample of my data:

      StatusHours
      Open6
      Open5
      Open8
      Open2

      Closed

      5
      Closed6
      Closed3

       

      I want to display the total number of open hours

      Open Hours
      19

       

      Right now I'm trying to do this using a table chart. I can get the sum by status easily enough, but I can't filter for open. Here's the expression I'm using:

      Sum({Status = 'Open'} [TOTAL [Hours])

       

      This is the template that pops up for expressions, but I'm lost on how to translate it into what I'm trying to do:

      Sum ({[SetExpression][DISTINCT][ALL][TOTAL[<fld{, fld}>]]} expr)

       

      Thanks in advance for any and all help!