topic Simple calculation: No value? in QlikView https://community.qlik.com/t5/QlikView/Simple-calculation-No-value/m-p/340032#M494625 <HTML><HEAD></HEAD><BODY><P>You need to tell it what to aggregate that's all. Do you want to sum your measure, count, count distinct etc? Because you could do count(JanProfit)/Count(JanRev) as well and it would intuitively produce different results. </P><P></P><P>I'm no expert however.</P></BODY></HTML> Thu, 05 Apr 2012 21:48:25 GMT 2012-04-05T21:48:25Z Simple calculation: No value? https://community.qlik.com/t5/QlikView/Simple-calculation-No-value/m-p/340029#M494622 <HTML><HEAD></HEAD><BODY><P>I've just started experimenting with QV. I added a simple gross margin calculation (JanProfit/JanRev) and ended up with a lot of null values (or whatever a minus means). </P><P></P><P>Any help would be greatly appreciated.</P><P></P><P><STRONG>RG</STRONG></P><P></P><P><IMG alt="20120405_QlikView_GrossMarginError.jpg" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/12746_20120405_QlikView_GrossMarginError.jpg" width="450" /></P></BODY></HTML> Thu, 05 Apr 2012 20:11:13 GMT https://community.qlik.com/t5/QlikView/Simple-calculation-No-value/m-p/340029#M494622 2012-04-05T20:11:13Z Simple calculation: No value? https://community.qlik.com/t5/QlikView/Simple-calculation-No-value/m-p/340030#M494623 <HTML><HEAD></HEAD><BODY><P> How about:</P><P>Sum(JanProfit)/Sum(JanRev)</P></BODY></HTML> Thu, 05 Apr 2012 20:59:08 GMT https://community.qlik.com/t5/QlikView/Simple-calculation-No-value/m-p/340030#M494623 m_woolf 2012-04-05T20:59:08Z Simple calculation: No value? https://community.qlik.com/t5/QlikView/Simple-calculation-No-value/m-p/340031#M494624 <HTML><HEAD></HEAD><BODY><P>That did it. Can you explain why however? </P></BODY></HTML> Thu, 05 Apr 2012 21:29:57 GMT https://community.qlik.com/t5/QlikView/Simple-calculation-No-value/m-p/340031#M494624 2012-04-05T21:29:57Z Simple calculation: No value? https://community.qlik.com/t5/QlikView/Simple-calculation-No-value/m-p/340032#M494625 <HTML><HEAD></HEAD><BODY><P>You need to tell it what to aggregate that's all. Do you want to sum your measure, count, count distinct etc? Because you could do count(JanProfit)/Count(JanRev) as well and it would intuitively produce different results. </P><P></P><P>I'm no expert however.</P></BODY></HTML> Thu, 05 Apr 2012 21:48:25 GMT https://community.qlik.com/t5/QlikView/Simple-calculation-No-value/m-p/340032#M494625 2012-04-05T21:48:25Z