topic How can i get this Frecuency... in QlikView

How can i get this Frecuency...

Mon, 10 Aug 2009 16:54:26 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!!!!!!!!!

How can i get this Frecuency...

Annette_Steinrücken — Mon, 10 Aug 2009 17:45:43 GMT

Hi,

What result do you expect for for example Calisas?

Regards, Annette

How can i get this Frecuency...

Tue, 11 Aug 2009 14:22:37 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!!!!!!!

Can you help me?..thanks........

How can i get this Frecuency...

Tue, 11 Aug 2009 15:20:01 GMT

Can you try this

=if(valor='1',sum(Peso) / count(All Chequeo))*100

-Raghu

How can i get this Frecuency...

Tue, 11 Aug 2009 17:27:58 GMT

Sorry, I want tis formula but with PESO:

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

How can i get this Frecuency...

Annette_Steinrücken — Tue, 11 Aug 2009 18:04:26 GMT

Hi,

if you look at your example: (1*0.87)+(0.999*1)/4, you want to build a sum of PESO * frequency of Chequeo.
Does this mean that you will have the same Peso for more than one Chequeo?

Do you have an example where you might have (2*0.87)?

/Annette

How can i get this Frecuency...

Tue, 11 Aug 2009 18:45:04 GMT

Yes, I have the same Peso for more than one Chequeo

I want to (the frequency) knows considered, that is to say the frequency when val=1 on val=2, bearing the weight in mind

Thanks.......Rose

How can i get this Frecuency...

johnw — Wed, 12 Aug 2009 01:11:10 GMT

Maybe this?

sum(if(Valor='1',Peso))/count(Chequeo)

As best I can tell, you don't need a count or Chequeo in the first part of the expression at all. You just want to sum up the Pesos where Valor = 1. If you have 0.87 Pesos twice, the sum() should count it twice (may depend on your exact data model). And I don't multiply by 100 because you can just display it as a percentage.