topic Condition in QlikView

Condition

Tue, 09 Jun 2009 18:22:48 GMT

Hello, good days, it would have a consultation, I want to do a weighted average, since(as,like) the formula is done, but in all that I have to put it of form condional, in order that it me works according to one year as filter, it me does not work. Someone might help.
Thank you, a greeting Rose

num

(if ([AÑO]=[Año]-1,(SUM(Valores*Peso)/SUM(Peso))),0.00)

Thanks

Condition

sathishkumar_go — Tue, 09 Jun 2009 18:29:25 GMT

Can u attach ur application?

-Sathish

Condition

Tue, 09 Jun 2009 18:37:59 GMT

I think bracket misplaced wrongly

Try this

=If([ANO]=[ANO]-1, (SUM(Valores*Peso)/Sum(Peso)),0.00))

-Raghu

Condition

Tue, 09 Jun 2009 19:47:09 GMT

Thank you, the formula works, but the campo YEAR is distint Year that is a variable, that is to say if I claim that selected changeable Year, actualize the formula.

Thank you.