topic Re: Count/sum single value in multiple lines in QlikView

Count/sum single value in multiple lines

pepe2209 — Fri, 27 Sep 2013 06:26:28 GMT

Hello

Please look at the example to better understand my question.

I want to do a sum(count) of the number of errors per section. The sections are reoccurring over time.

DATA:

TABLE that I want to produce

I hope someone can help me with this.

tresB — Fri, 27 Sep 2013 06:34:31 GMT

With given data, how is C - 3 ? Can you please explain the logic?

abeyphilip — Fri, 27 Sep 2013 08:09:58 GMT

Hi Peter,

Are you looking for something like the Sum table in the attached eg.

Regards,

Abey

EDIT - Updated with calculation for total.

pepe2209 — Fri, 27 Sep 2013 10:12:05 GMT

Yes thanks this seems to work perfectly!

Trying to figure out the formula for myself but this helps me a lot

Thanks.