Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

FRECUENCY ABSOLUT

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!!!!!!!!!



Labels (1)
2 Replies
johnw
Champion III
Champion III

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

Not applicable
Author

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