topic Re: Problem with totals in table in QlikView

Problem with totals in table

Sun, 15 Feb 2015 17:28:02 GMT

Hi, I have this problem:

I calcule "Sueldo hora" with "Sueldo Mes"/"Total Horas", but I have two "Proyectos" I can filter, P1 and P2. When I filter by a proyect, I have:

In the last column I want to have (10*30)+(15*50)=1050, and I have 1000.

Someone can help me? I send the file attached.

Thanks.

Frank_Hartmann — Sun, 15 Feb 2015 17:37:40 GMT

have a look at the attached file,

chart properties-->Expressions-->TotalMode-->sum of rows

cheers

Sun, 15 Feb 2015 17:42:45 GMT

Hi,

Since you're using a straight table, you could sum up the rows as Frank suggested.

If you want to use a pivot, you'd need to aggregate by Recurso, just modify your expression as:

sum(aggr(

Sum(Horas)*(sum(Sueldo)/12)*count(distinct(Mes))/Sum({<Proyecto=>}Horas)

, Recurso))