topic REGARDING SOME CALCULATION in QlikView https://community.qlik.com/t5/QlikView/REGARDING-SOME-CALCULATION/m-p/197741#M57298 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Just open the qvw file there u can see i am facing problem in getting sum.</P><P>Waiting for reply??????</P></BODY></HTML> Tue, 29 Dec 2009 17:02:17 GMT qliksus 2009-12-29T17:02:17Z REGARDING SOME CALCULATION https://community.qlik.com/t5/QlikView/REGARDING-SOME-CALCULATION/m-p/197741#M57298 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Just open the qvw file there u can see i am facing problem in getting sum.</P><P>Waiting for reply??????</P></BODY></HTML> Tue, 29 Dec 2009 17:02:17 GMT https://community.qlik.com/t5/QlikView/REGARDING-SOME-CALCULATION/m-p/197741#M57298 qliksus 2009-12-29T17:02:17Z REGARDING SOME CALCULATION https://community.qlik.com/t5/QlikView/REGARDING-SOME-CALCULATION/m-p/197742#M57299 <HTML><HEAD></HEAD><BODY><P>Try this..</P><P>Sum({$&lt;closingstock={"&gt;0"}&gt;} Sale)</P><P>When you use the if-statements, you will often multiply you your rows when your conditinal sum depends on a value from another table.</P><P>This was not an issue up to version 8, but from 8.5 and onwards, it seems like the only thing that handle this correctly is "Set analysis"</P><P></P><P>/Martin</P></BODY></HTML> Tue, 29 Dec 2009 18:29:32 GMT https://community.qlik.com/t5/QlikView/REGARDING-SOME-CALCULATION/m-p/197742#M57299 2009-12-29T18:29:32Z REGARDING SOME CALCULATION https://community.qlik.com/t5/QlikView/REGARDING-SOME-CALCULATION/m-p/197743#M57300 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Thanks for reply. It's works fine .</P></BODY></HTML> Tue, 29 Dec 2009 19:37:50 GMT https://community.qlik.com/t5/QlikView/REGARDING-SOME-CALCULATION/m-p/197743#M57300 qliksus 2009-12-29T19:37:50Z