topic FRECUENCY ABSOLUT in QlikView

FRECUENCY ABSOLUT

Mon, 10 Aug 2009 15:37:19 GMT

Hello, I Would like to find the formula to obtain the relative frequency for a weight, for example:

I have one variable Chequeo with valors (1 or 2) and for each valor there is one Peso :

Valor Peso Chequeo

1 0.87 Calidad

1 0.999 Calidad

2 1.335 Servicios

2 0.85 Automóviles

and I would like to find:

(count(if ((Valor='1'),Chequeo))/count(Chequeo))*100

but I have to bear the weight in mind .

THANKS!!!!!!!!!

johnw — Tue, 11 Aug 2009 01:58:54 GMT

I'm not entirely following. What do you want to see in your chart for the example data?

Tue, 11 Aug 2009 14:19:11 GMT

For example: the frecuency from variable=Chequeo....of Calidad is 2/4 but, I want to obtain:

Count( Chequeo*Peso) / Count(Chequeo): is the same: (1*0.87)+(0.999*1)/4, if only where Valor=1

(count(if ((Valor='1'),Chequeo*Peso))/count(Chequeo))*100.......... it`s wrong!!!!!!!

Thanks