topic Re: Sum issue in QlikView

Sum issue

Mon, 30 Sep 2013 06:27:58 GMT

Good day,

Boss for all workers = Jan

But Jan is also on some of the jobs. I want to split the 'Nr' between Jan and the rest.

The problem is, I need the total for Jan to be 1+1+1+1+1+1+1+1+1+1 = 10

and not

1+1+1+1+1+1+1+1+1+1 * 10 = 100

Is there any way to do that, I cant use Max as some of the 'Nr' s won't be 1

See attached

Please help

ariel_klien — Tue, 01 Oct 2013 11:59:53 GMT

Hi,

Go to Chart properties > Expressions Tab and in the

in the Jan expression put: IF([Boss]=[Worker],[Nr],0)

and in the Total mode select sum of rowas.

hope this will help you.

Ariel

CELAMBARASAN — Tue, 01 Oct 2013 12:53:57 GMT

Try with this

Sum({<JobCode={"=[Boss]=[Worker]"}>} [Nr])