topic Re: Como modificar Formula dinamicamente in QlikView https://community.qlik.com/t5/QlikView/Como-modificar-Formula-dinamicamente/m-p/359184#M133315 <HTML><HEAD></HEAD><BODY><P>Gracias marco ya abrio el qvw </P><P>es justo lo que buscaba</P><P></P><P></P><P>Muchas gracias exitos....</P></BODY></HTML> Thu, 19 Jul 2012 19:16:10 GMT 2012-07-19T19:16:10Z Como modificar Formula dinamicamente https://community.qlik.com/t5/QlikView/Como-modificar-Formula-dinamicamente/m-p/359182#M133313 <HTML><HEAD></HEAD><BODY><P>Buen dia </P><P>¿se puede poner la formulacion en forma dinamica?</P><P>a loque me refiereo es que podria tener </P><P>una tabla Valores</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="139" style="border: 1px solid rgb(0, 0, 0); width: 413px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>DIRECION<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Area<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Total</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>A<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>B<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>C</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>D<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>E</STRONG></SPAN></TH></TR><TR><TD>PPPP</TD><TD>AAAA</TD><TD>150</TD><TD>100</TD><TD>50</TD><TD>80</TD><TD>15</TD><TD>5</TD></TR><TR><TD>PPPP</TD><TD>BBBB</TD><TD>200</TD><TD>180</TD><TD>20</TD><TD>150</TD><TD>20</TD><TD>10</TD></TR><TR><TD>QQQQ</TD><TD>SSSS</TD><TD>180</TD><TD>160</TD><TD>20</TD><TD>160</TD><TD>0</TD><TD><P>0</P></TD></TR><TR><TD>QQQQ</TD><TD>TTTTT</TD><TD>300</TD><TD>250</TD><TD>20</TD><TD>200</TD><TD>30</TD><TD>20</TD></TR><TR><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR></TBODY></TABLE><P></P><P>Otra Tabla Formulas</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="70" style="border: 1px solid rgb(0, 0, 0); width: 532px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>DIRECCION</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>METRICA<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>FORMULA<BR /></STRONG></SPAN></TH></TR><TR><TD>PPPP</TD><TD>AXY</TD><TD> (A+B+D)/TOTAL</TD></TR><TR><TD>QQQQ</TD><TD>AXY</TD><TD>(A+B+C)/(TOTAL+E)</TD></TR></TBODY></TABLE><P></P><P></P><P>y con ellas replazar la Fomrula segun DIRECCION y que te realize el calculo con la formula que le corresponde es decir</P><P>reportar una tabla </P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="116" style="border: 1px solid rgb(0, 0, 0); width: 312px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>DIRECCION <BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>AREA<BR /></STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>AXY</STRONG></SPAN></TH></TR><TR><TD>PPPP</TD><TD>AAAA</TD><TD>1.1</TD></TR><TR><TD>PPPP</TD><TD>BBBB</TD><TD>1.05</TD></TR><TR><TD>QQQQ</TD><TD>SSSS</TD><TD><P>1.88</P></TD></TR><TR><TD>QQQQ</TD><TD>TTTTT</TD><TD>1.46</TD></TR></TBODY></TABLE><P></P><P>alguna idea o alguien que lo hay realizado antes...</P><P></P><P>Gracias de antemano por sus sugerencias</P></BODY></HTML> Thu, 19 Jul 2012 17:20:36 GMT https://community.qlik.com/t5/QlikView/Como-modificar-Formula-dinamicamente/m-p/359182#M133313 2012-07-19T17:20:36Z Re: Como modificar Formula dinamicamente https://community.qlik.com/t5/QlikView/Como-modificar-Formula-dinamicamente/m-p/359183#M133314 <HTML><HEAD></HEAD><BODY><P>hello do you have a personal edition? i post to you my files that it calcute by script the formula.</P><P>I hope for you </P><P></P><P>thanks </P><P>Marchetto</P></BODY></HTML> Thu, 19 Jul 2012 17:31:24 GMT https://community.qlik.com/t5/QlikView/Como-modificar-Formula-dinamicamente/m-p/359183#M133314 2012-07-19T17:31:24Z Re: Como modificar Formula dinamicamente https://community.qlik.com/t5/QlikView/Como-modificar-Formula-dinamicamente/m-p/359184#M133315 <HTML><HEAD></HEAD><BODY><P>Gracias marco ya abrio el qvw </P><P>es justo lo que buscaba</P><P></P><P></P><P>Muchas gracias exitos....</P></BODY></HTML> Thu, 19 Jul 2012 19:16:10 GMT https://community.qlik.com/t5/QlikView/Como-modificar-Formula-dinamicamente/m-p/359184#M133315 2012-07-19T19:16:10Z