topic Re: Need help !!!!!!!! in QlikView https://community.qlik.com/t5/QlikView/Need-help/m-p/612646#M226084 <HTML><HEAD></HEAD><BODY><P>try with</P><P></P><P>=count(if (aggr(CAS_Date_Value1-CAS_Date_Value2, CAD_Activity_ID, CAM_ID)&gt;0, CAM_ID) )</P><P></P><P>instead of </P><P>=if(vVarience &gt;0,count(vVarience))</P></BODY></HTML> Wed, 23 Apr 2014 17:03:12 GMT maxgro 2014-04-23T17:03:12Z Need help !!!!!!!! https://community.qlik.com/t5/QlikView/Need-help/m-p/612645#M226083 <HTML><HEAD></HEAD><BODY><P>Hi All ,</P><P></P><P> I have QVW doc i calculated variance buy using actual(A) and&nbsp; Target(T)</P><P></P><P>Finally I got some value Now i want to calculate count </P><P></P><P>how may 0 are there in my variance i want calculate in&nbsp; any object</P><P>as well &lt;0 how may are there like that</P><P></P><P></P><P>please see the attachments</P></BODY></HTML> Wed, 23 Apr 2014 16:55:38 GMT https://community.qlik.com/t5/QlikView/Need-help/m-p/612645#M226083 2014-04-23T16:55:38Z Re: Need help !!!!!!!! https://community.qlik.com/t5/QlikView/Need-help/m-p/612646#M226084 <HTML><HEAD></HEAD><BODY><P>try with</P><P></P><P>=count(if (aggr(CAS_Date_Value1-CAS_Date_Value2, CAD_Activity_ID, CAM_ID)&gt;0, CAM_ID) )</P><P></P><P>instead of </P><P>=if(vVarience &gt;0,count(vVarience))</P></BODY></HTML> Wed, 23 Apr 2014 17:03:12 GMT https://community.qlik.com/t5/QlikView/Need-help/m-p/612646#M226084 maxgro 2014-04-23T17:03:12Z