topic Consulting in QlikView https://community.qlik.com/t5/QlikView/Consulting/m-p/146279#M24870 <HTML><HEAD></HEAD><BODY><P>Hello, more and less, but It has been of great help, thanks you very much.</P></BODY></HTML> Wed, 10 Jun 2009 19:16:47 GMT 2009-06-10T19:16:47Z Consulting https://community.qlik.com/t5/QlikView/Consulting/m-p/146277#M24868 <HTML><HEAD></HEAD><BODY><P>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.<BR />Thank you, a greeting Rose</P><P></P><P></P><P>num</P><P></P><P>(if ([AÑO]=[Año]-1,(SUM(Valores*Peso)/SUM(Peso))),0.00)</P><P></P><P></P><P>Thanks</P><BR /><BR /> <BR /><BR /> <P></P></BODY></HTML> Tue, 09 Jun 2009 17:17:18 GMT https://community.qlik.com/t5/QlikView/Consulting/m-p/146277#M24868 2009-06-09T17:17:18Z Consulting https://community.qlik.com/t5/QlikView/Consulting/m-p/146278#M24869 <HTML><HEAD></HEAD><BODY><P style="margin:0in 0in 0pt;">I'm sorry if I don't understand. Maybe this?</P><P style="margin:0in 0in 0pt;"></P><P style="margin:0in 0in 0pt;">sum(if([AÑO]=[Año]-1,Valores*Peso))</P><P style="margin:0in 0in 0pt;">/sum(if([AÑO]=[Año]-1, Peso))</P></BODY></HTML> Wed, 10 Jun 2009 00:28:52 GMT https://community.qlik.com/t5/QlikView/Consulting/m-p/146278#M24869 johnw 2009-06-10T00:28:52Z Consulting https://community.qlik.com/t5/QlikView/Consulting/m-p/146279#M24870 <HTML><HEAD></HEAD><BODY><P>Hello, more and less, but It has been of great help, thanks you very much.</P></BODY></HTML> Wed, 10 Jun 2009 19:16:47 GMT https://community.qlik.com/t5/QlikView/Consulting/m-p/146279#M24870 2009-06-10T19:16:47Z