topic Total of the expression. in QlikView https://community.qlik.com/t5/QlikView/Total-of-the-expression/m-p/246862#M94069 <HTML><HEAD></HEAD><BODY><P>Ah, you are talking about CONCEPTO=TESTE2 ?</P><P></P><P>03 month / 2011 is 30 and I get a total for the year of 430. If I select only 01 month and 02 month, I get 400 displayed. Not what you expected?</P></BODY></HTML> Tue, 03 Jan 2012 12:56:14 GMT swuehl 2012-01-03T12:56:14Z Total of the expression. https://community.qlik.com/t5/QlikView/Total-of-the-expression/m-p/246859#M94066 <HTML><HEAD></HEAD><BODY><P>Because the sum in the TOTAL column values ​​do not match?</P></BODY></HTML> Tue, 03 Jan 2012 12:12:57 GMT https://community.qlik.com/t5/QlikView/Total-of-the-expression/m-p/246859#M94066 Anonymous 2012-01-03T12:12:57Z Total of the expression. https://community.qlik.com/t5/QlikView/Total-of-the-expression/m-p/246860#M94067 <HTML><HEAD></HEAD><BODY><P>Sorry, you probably need to add what you want to see...</P><P></P><P>If you want to see values for 2011 and 2010 resp., you could use the set expressions that are commented in your expressions, already in your application. Then values seem reasonably to me, also Teste3.</P><P></P><P>Maybe I just don't understand what you are after.</P></BODY></HTML> Tue, 03 Jan 2012 12:25:53 GMT https://community.qlik.com/t5/QlikView/Total-of-the-expression/m-p/246860#M94067 swuehl 2012-01-03T12:25:53Z Total of the expression. https://community.qlik.com/t5/QlikView/Total-of-the-expression/m-p/246861#M94068 <HTML><HEAD></HEAD><BODY><P>Note that the </P><P>01 month / 2,011 = 120.00, </P><P>02 month / 2011 = 280.00.</P><P></P><P>The total should be 400.00</P></BODY></HTML> Tue, 03 Jan 2012 12:36:47 GMT https://community.qlik.com/t5/QlikView/Total-of-the-expression/m-p/246861#M94068 Anonymous 2012-01-03T12:36:47Z Total of the expression. https://community.qlik.com/t5/QlikView/Total-of-the-expression/m-p/246862#M94069 <HTML><HEAD></HEAD><BODY><P>Ah, you are talking about CONCEPTO=TESTE2 ?</P><P></P><P>03 month / 2011 is 30 and I get a total for the year of 430. If I select only 01 month and 02 month, I get 400 displayed. Not what you expected?</P></BODY></HTML> Tue, 03 Jan 2012 12:56:14 GMT https://community.qlik.com/t5/QlikView/Total-of-the-expression/m-p/246862#M94069 swuehl 2012-01-03T12:56:14Z Total of the expression. https://community.qlik.com/t5/QlikView/Total-of-the-expression/m-p/246863#M94070 <HTML><HEAD></HEAD><BODY><P> I managed to solve:</P><P></P><P>replace the column formula TOTAL :</P><P></P><P>sum( (VENDA*12)/(360/((ESTOQUE/VENDA)*30)))</P><P></P><P></P><P><SPAN class="hps">thank you...</SPAN></P></BODY></HTML> Tue, 03 Jan 2012 13:12:07 GMT https://community.qlik.com/t5/QlikView/Total-of-the-expression/m-p/246863#M94070 Anonymous 2012-01-03T13:12:07Z Total of the expression. https://community.qlik.com/t5/QlikView/Total-of-the-expression/m-p/246864#M94071 <HTML><HEAD></HEAD><BODY><P>Good to hear that you solved your problem.</P><P></P><P>Since I can't see a column TOTAL in your attached sample file, I think you are maybe referring to a different app. Would explain some things..</P></BODY></HTML> Tue, 03 Jan 2012 13:15:27 GMT https://community.qlik.com/t5/QlikView/Total-of-the-expression/m-p/246864#M94071 swuehl 2012-01-03T13:15:27Z Re: Total of the expression. https://community.qlik.com/t5/QlikView/Total-of-the-expression/m-p/246865#M94072 <HTML><HEAD></HEAD><BODY><P>Sorry, I have attached the wrong application, follows the new.</P></BODY></HTML> Tue, 03 Jan 2012 13:24:33 GMT https://community.qlik.com/t5/QlikView/Total-of-the-expression/m-p/246865#M94072 Anonymous 2012-01-03T13:24:33Z