topic Re: Wrong Total Sum in QlikView https://community.qlik.com/t5/QlikView/Wrong-Total-Sum/m-p/873265#M305080 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Thank you for your reply, </P><P></P><P>If you do clic on ene -7 show fine</P><P><SPAN style="font-size: 13.3333px;">If you do clic on feb -7 show fine until that my sum is correct (-14)</SPAN></P><P><SPAN style="font-size: 13.3333px;">but if you do clic on mar show fine (-2) the total sum is wrong (show -22 instead of -16) and so on...</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Thanks!<BR /></SPAN></P></BODY></HTML> Thu, 11 Jun 2015 12:33:51 GMT pgalvezt 2015-06-11T12:33:51Z Wrong Total Sum https://community.qlik.com/t5/QlikView/Wrong-Total-Sum/m-p/873263#M305078 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>I have a set analysys that works fine but the total acummulate for months is wrong. I will expect -18 instead of -29.</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 11 Jun 2015 12:06:07 GMT https://community.qlik.com/t5/QlikView/Wrong-Total-Sum/m-p/873263#M305078 pgalvezt 2015-06-11T12:06:07Z Re: Wrong Total Sum https://community.qlik.com/t5/QlikView/Wrong-Total-Sum/m-p/873264#M305079 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>that isn't a set analysis but an expression with many nested if statement.</P><P>Do you want that your formula shows a different result concording with selection?</P><P>S.</P></BODY></HTML> Thu, 11 Jun 2015 12:28:22 GMT https://community.qlik.com/t5/QlikView/Wrong-Total-Sum/m-p/873264#M305079 simospa 2015-06-11T12:28:22Z Re: Wrong Total Sum https://community.qlik.com/t5/QlikView/Wrong-Total-Sum/m-p/873265#M305080 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Thank you for your reply, </P><P></P><P>If you do clic on ene -7 show fine</P><P><SPAN style="font-size: 13.3333px;">If you do clic on feb -7 show fine until that my sum is correct (-14)</SPAN></P><P><SPAN style="font-size: 13.3333px;">but if you do clic on mar show fine (-2) the total sum is wrong (show -22 instead of -16) and so on...</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Thanks!<BR /></SPAN></P></BODY></HTML> Thu, 11 Jun 2015 12:33:51 GMT https://community.qlik.com/t5/QlikView/Wrong-Total-Sum/m-p/873265#M305080 pgalvezt 2015-06-11T12:33:51Z Re: Wrong Total Sum https://community.qlik.com/t5/QlikView/Wrong-Total-Sum/m-p/873266#M305081 <HTML><HEAD></HEAD><BODY><P>Done!</P><P></P><P>The Solution was put</P><P>Round(</P><P>Sum(Aggr(Formula),IdContable),2)</P><P></P><P>Thanks!</P></BODY></HTML> Thu, 11 Jun 2015 15:04:39 GMT https://community.qlik.com/t5/QlikView/Wrong-Total-Sum/m-p/873266#M305081 pgalvezt 2015-06-11T15:04:39Z