topic Extremely large. in QlikView https://community.qlik.com/t5/QlikView/Extremely-large/m-p/229919#M81796 <HTML><HEAD></HEAD><BODY><P>Perhaps this?</P><P style="padding-left:30px;">rangemax(0,my formula)</P></BODY></HTML> Wed, 22 Dec 2010 01:53:13 GMT johnw 2010-12-22T01:53:13Z Extremely large. https://community.qlik.com/t5/QlikView/Extremely-large/m-p/229918#M81795 <HTML><HEAD></HEAD><BODY><P>I have a formula that brings a great result and that this result can not be negative. I'm using the "IF ". EX: "IF (my formula &lt;0, 0, my formula). " Almost have to repeat the formula again. Is there a more practical way to do this?</P><P></P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">if(</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"></P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">if(STATUS_COMPRA='N',0,</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">if([Simulador Cresc. Estoque]=0,</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">(([Suficiencia_Planejada_Estoque]*(<B><I>$(VR_PREVISAO_VENDAS)</I></B>/30))</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">-([Estoque Virtual no Ponto do Pedido]-[Reposição Quant. de Venda Prevista])),</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">if(</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">(([Estoque Virtual no Ponto Antes do Recebimento do Pedido]+</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">((sum(QTDE_ESTOQUE)*(1+[Simulador Cresc. Estoque]))-[Estoque Virtual no Ponto Antes do Recebimento do Pedido]))</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">/sum(<B><I>$(VR_Quantidade_Venda_Prevista)</I></B>))*30</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">&lt;=[Suficiencia_Planejada_Estoque],</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">((sum(QTDE_ESTOQUE)*(1+[Simulador Cresc. Estoque]))-[Estoque Virtual no Ponto Antes do Recebimento do Pedido]),</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">(([Suficiencia_Planejada_Estoque]*(<B><I>$(VR_PREVISAO_VENDAS)</I></B>/30))</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">-([Estoque Virtual no Ponto do Pedido]-[Reposição Quant. de Venda Prevista])))))&lt;0,0,</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"></P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;"></P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">if(STATUS_COMPRA='N',0,</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">if([Simulador Cresc. Estoque]=0,</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">(([Suficiencia_Planejada_Estoque]*(<B><I>$(VR_PREVISAO_VENDAS)</I></B>/30))</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">-([Estoque Virtual no Ponto do Pedido]-[Reposição Quant. de Venda Prevista])),</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">if(</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">(([Estoque Virtual no Ponto Antes do Recebimento do Pedido]+</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">((sum(QTDE_ESTOQUE)*(1+[Simulador Cresc. Estoque]))-[Estoque Virtual no Ponto Antes do Recebimento do Pedido]))</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">/sum(<B><I>$(VR_Quantidade_Venda_Prevista)</I></B>))*30</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">&lt;=[Suficiencia_Planejada_Estoque],</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">((sum(QTDE_ESTOQUE)*(1+[Simulador Cresc. Estoque]))-[Estoque Virtual no Ponto Antes do Recebimento do Pedido]),</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">(([Suficiencia_Planejada_Estoque]*(<B><I>$(VR_PREVISAO_VENDAS)</I></B>/30))</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">-([Estoque Virtual no Ponto do Pedido]-[Reposição Quant. de Venda Prevista])))))</P><P style="line-height: normal; margin: 0cm 0cm 0pt; mso-layout-grid-align: none;">)</P><P></P><P></P><BR /><BR /></BODY></HTML> Tue, 21 Dec 2010 21:03:51 GMT https://community.qlik.com/t5/QlikView/Extremely-large/m-p/229918#M81795 Anonymous 2010-12-21T21:03:51Z Extremely large. https://community.qlik.com/t5/QlikView/Extremely-large/m-p/229919#M81796 <HTML><HEAD></HEAD><BODY><P>Perhaps this?</P><P style="padding-left:30px;">rangemax(0,my formula)</P></BODY></HTML> Wed, 22 Dec 2010 01:53:13 GMT https://community.qlik.com/t5/QlikView/Extremely-large/m-p/229919#M81796 johnw 2010-12-22T01:53:13Z Extremely large. https://community.qlik.com/t5/QlikView/Extremely-large/m-p/229920#M81797 <HTML><HEAD></HEAD><BODY><P>Thanks, it worked.</P></BODY></HTML> Wed, 22 Dec 2010 12:37:28 GMT https://community.qlik.com/t5/QlikView/Extremely-large/m-p/229920#M81797 Anonymous 2010-12-22T12:37:28Z