topic Re: condition on max inside sum function in QlikView https://community.qlik.com/t5/QlikView/condition-on-max-inside-sum-function/m-p/393639#M146768 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Try like this</P><P></P><P>=Count({&lt;Status = {'active'},Weekingdate ={'$(=max(Weekingday))'}&gt;}Candidateid)</P><P></P><P>but when weekingdate is maximum ? represents sunday or something else?? </P><P>bit confuse. can you explain it?</P><P></P><P>Hope it helps</P></BODY></HTML> Thu, 01 Nov 2012 19:30:50 GMT MayilVahanan 2012-11-01T19:30:50Z condition on max inside sum function https://community.qlik.com/t5/QlikView/condition-on-max-inside-sum-function/m-p/393638#M146767 <HTML><HEAD></HEAD><BODY><P>Hello, If I want to take the count of candidateid when weekingdate is maximum and status='active', then how can I write the set analysis function for this</P><P></P><P>Thanks</P><P>Arif</P></BODY></HTML> Thu, 01 Nov 2012 19:27:13 GMT https://community.qlik.com/t5/QlikView/condition-on-max-inside-sum-function/m-p/393638#M146767 2012-11-01T19:27:13Z Re: condition on max inside sum function https://community.qlik.com/t5/QlikView/condition-on-max-inside-sum-function/m-p/393639#M146768 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Try like this</P><P></P><P>=Count({&lt;Status = {'active'},Weekingdate ={'$(=max(Weekingday))'}&gt;}Candidateid)</P><P></P><P>but when weekingdate is maximum ? represents sunday or something else?? </P><P>bit confuse. can you explain it?</P><P></P><P>Hope it helps</P></BODY></HTML> Thu, 01 Nov 2012 19:30:50 GMT https://community.qlik.com/t5/QlikView/condition-on-max-inside-sum-function/m-p/393639#M146768 MayilVahanan 2012-11-01T19:30:50Z