topic Re: Issue in Expression-Count not correct in QlikView https://community.qlik.com/t5/QlikView/Issue-in-Expression-Count-not-correct/m-p/590727#M219129 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Try like this</P><P>=Sum(Aggr(Interval(MAX_SMOKE_QA_TIMESTAMP-JOIN_DT,'d'),PERSON_ADDM2_KEY))</P></BODY></HTML> Mon, 03 Mar 2014 08:37:18 GMT MayilVahanan 2014-03-03T08:37:18Z Issue in Expression-Count not correct https://community.qlik.com/t5/QlikView/Issue-in-Expression-Count-not-correct/m-p/590726#M219128 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>PFA for the Sample QVW.</P><P></P><P><IMG alt="Test.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/54117_Test.jpg" style="width: 620px; height: 35px;" /></P><P>This works when i select for one person.</P><P>For Person_addm2_key = 418 it is <STRONG>384 </STRONG></P><P>and for Person_addm2_key = 429 its is <STRONG>121.</STRONG></P><P></P><P></P><P><IMG alt="Test.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/54118_Test.jpg" /></P><P>when i select both the PErson_addm2_key i should get the value : 384 + 121=505</P><P>But i am getting no values.</P><P></P><P></P><P><IMG alt="Test.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/54125_Test.jpg" /></P><P>can you please check the expression and help?</P></BODY></HTML> Mon, 03 Mar 2014 08:24:21 GMT https://community.qlik.com/t5/QlikView/Issue-in-Expression-Count-not-correct/m-p/590726#M219128 2014-03-03T08:24:21Z Re: Issue in Expression-Count not correct https://community.qlik.com/t5/QlikView/Issue-in-Expression-Count-not-correct/m-p/590727#M219129 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Try like this</P><P>=Sum(Aggr(Interval(MAX_SMOKE_QA_TIMESTAMP-JOIN_DT,'d'),PERSON_ADDM2_KEY))</P></BODY></HTML> Mon, 03 Mar 2014 08:37:18 GMT https://community.qlik.com/t5/QlikView/Issue-in-Expression-Count-not-correct/m-p/590727#M219129 MayilVahanan 2014-03-03T08:37:18Z