topic Re: SUM BY GROUP in QlikView

SUM BY GROUP

Mon, 15 Oct 2012 12:31:46 GMT

Hi,

Like a count group by category:

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

is it possible to do a SUM?

By exemple:

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)

Re: SUM BY GROUP

Gysbert_Wassenaar — Mon, 15 Oct 2012 12:33:57 GMT

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

Re: SUM BY GROUP

Mon, 15 Oct 2012 12:37:27 GMT

Thank you for your answer but it didn’t work.

Here is the result of your solution.

I think it SUM all data from database but not only the displayed value.

Re: SUM BY GROUP

Gysbert_Wassenaar — Mon, 15 Oct 2012 12:51:38 GMT

In your screenshot you can see that the sum is grouped by DateProd and ligne and that the sum for Journée is 0. As far as I can see the expression does what you asked. If it's not correct you need to explain more. It would help if you could share the qvw file you're working on.

Re: SUM BY GROUP

Mon, 15 Oct 2012 12:54:31 GMT

Your are right J

During the time I ask my question and your answer I renamed one column (the cause of the error).

Thank you’re a lot for your quickly help.

Pierre

Re: SUM BY GROUP

chematos — Mon, 15 Oct 2012 12:56:52 GMT

Ttry this:

Aggr() function is like a group by, you need to specify the grouping fields after the sum()

aggr(sum({< HoraireName -= {'Journée'} >} HPrest),HoraireName, Ligne, DateProd)

Regards