topic How calculate the percentage? in QlikView

How calculate the percentage?

carlos13 — Mon, 03 Sep 2012 21:51:20 GMT

From the Field "ESTRATEGICOS_OBJ_NOMBRE" that has the following values

Calculate the percentage

And I want to get the overall percentage including

But using “sum(total<ESTRATEGICOS_OBJ_NOMBRE,Nombre,IND_NOMBRE> OBJETIVOS_OBJ_PORCENTAJE/100) ” not working

nor with “Avg(total<ESTRATEGICOS_OBJ_NOMBRE,Nombre,IND_NOMBRE> OBJETIVOS_OBJ_PORCENTAJE/100)”

I appreciate any help in advance

I add the example of what I'm working pair to see if I can help.

thanks

whiteline — Tue, 04 Sep 2012 04:49:40 GMT

Don't now if its logicaly right, but I think I've got what you want.

Use this expression:

=avg({$<Nombre={"=Len(Nombre)>0"}>}IF(RSP_CLASE=2,OBJETIVOS_OBJ_PORCENTAJE/100))

And UnCheck 'Supress Zero-Values' on Presentation tab.

carlos13 — Tue, 04 Sep 2012 15:07:06 GMT

thank