topic Working with Range Doubt - 2 in QlikView https://community.qlik.com/t5/QlikView/Working-with-Range-Doubt-2/m-p/270980#M101607 <HTML><HEAD></HEAD><BODY><P>Hello everyone. </P><P></P><P>Last problem i have was about dealing with extremes in a períod, that problem was solved by John on this post <A _jive_internal="true" href="https://community.qlik.com/message/121539#121539">http://community.qlik.com/message/121539#121539</A>. Thanks again John.</P><P></P><P>Now i'm tring to use the same way (triggering comands) to work with float fields. Everything works perfectly when i work with a single float collumn, i'm using a trigger to this command "='=Valor_Venda &gt;= varValorCorte'". But when i do the same in a collumn wich is the result of a SUM between two fields, nothing happened, i tried this command "='=SUM(Valor_Venda) - SUM(Valor_Liquido) &gt;= varValorCorte"</P><P></P><P>Is there a way to achieve the same select effect in a field that is made by a SUM or a calculation ?</P><P></P><P>Thaks again for the support.</P><P></P><P></P><P></P></BODY></HTML> Wed, 08 Jun 2011 00:54:19 GMT 2011-06-08T00:54:19Z Working with Range Doubt - 2 https://community.qlik.com/t5/QlikView/Working-with-Range-Doubt-2/m-p/270980#M101607 <HTML><HEAD></HEAD><BODY><P>Hello everyone. </P><P></P><P>Last problem i have was about dealing with extremes in a períod, that problem was solved by John on this post <A _jive_internal="true" href="https://community.qlik.com/message/121539#121539">http://community.qlik.com/message/121539#121539</A>. Thanks again John.</P><P></P><P>Now i'm tring to use the same way (triggering comands) to work with float fields. Everything works perfectly when i work with a single float collumn, i'm using a trigger to this command "='=Valor_Venda &gt;= varValorCorte'". But when i do the same in a collumn wich is the result of a SUM between two fields, nothing happened, i tried this command "='=SUM(Valor_Venda) - SUM(Valor_Liquido) &gt;= varValorCorte"</P><P></P><P>Is there a way to achieve the same select effect in a field that is made by a SUM or a calculation ?</P><P></P><P>Thaks again for the support.</P><P></P><P></P><P></P></BODY></HTML> Wed, 08 Jun 2011 00:54:19 GMT https://community.qlik.com/t5/QlikView/Working-with-Range-Doubt-2/m-p/270980#M101607 2011-06-08T00:54:19Z