topic Re: Set Analysis with a count condition in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-with-a-count-condition/m-p/1294999#M825738 <HTML><HEAD></HEAD><BODY><P>Don't think that will help.... what we need is to know what dimension are we doing this count on...</P></BODY></HTML> Wed, 12 Jul 2017 17:09:32 GMT sunny_talwar 2017-07-12T17:09:32Z Set Analysis with a count condition https://community.qlik.com/t5/QlikView/Set-Analysis-with-a-count-condition/m-p/1294994#M825731 <HTML><HEAD></HEAD><BODY><P>I need a set analysis to calculate an expression which should satisfy a count condition and it should look something like this:</P><P></P><P>=Sum({$&lt;Count(case)={"&gt;$(=1)"}&gt;} [POST DATE]- Max (SERV_DATE))</P><P></P><P>"case" is an autonumbered field created in the script and is a combination of three other fields. But the above set analysis expression that I created is not working. Would appreciate any help or ideas, thanks!</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-a-count-condition/m-p/1294994#M825731 Anonymous 2020-11-25T16:16:04Z Re: Set Analysis with a count condition https://community.qlik.com/t5/QlikView/Set-Analysis-with-a-count-condition/m-p/1294995#M825732 <HTML><HEAD></HEAD><BODY><P>Against which dimension are you doing this Count(case) check against? POST DATE? SERV_DATE? What is the difference between the two dates here? and why use Max(SERV_DATE)?</P></BODY></HTML> Wed, 12 Jul 2017 16:29:26 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-a-count-condition/m-p/1294995#M825732 sunny_talwar 2017-07-12T16:29:26Z Re: Set Analysis with a count condition https://community.qlik.com/t5/QlikView/Set-Analysis-with-a-count-condition/m-p/1294996#M825733 <HTML><HEAD></HEAD><BODY><P>You cannot use Aggr function like Count() on left of the "=" </P><P></P><P>May be like:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=Sum({$&lt;case ={"=$(= Count(case) &gt; 1)"}&gt;} [POST DATE]- Max (SERV_DATE))</SPAN></P></BODY></HTML> Wed, 12 Jul 2017 16:48:53 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-a-count-condition/m-p/1294996#M825733 vishsaggi 2017-07-12T16:48:53Z Re: Set Analysis with a count condition https://community.qlik.com/t5/QlikView/Set-Analysis-with-a-count-condition/m-p/1294997#M825734 <HTML><HEAD></HEAD><BODY><P>case is an autonumbered field.... so Count(case) against case will always = 1</P></BODY></HTML> Wed, 12 Jul 2017 16:53:55 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-a-count-condition/m-p/1294997#M825734 sunny_talwar 2017-07-12T16:53:55Z Re: Set Analysis with a count condition https://community.qlik.com/t5/QlikView/Set-Analysis-with-a-count-condition/m-p/1294998#M825736 <HTML><HEAD></HEAD><BODY><P>Oops got it. Thanks for that. Can you do a Sum(Aggr(Count(case), case)) ? </P></BODY></HTML> Wed, 12 Jul 2017 17:06:49 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-a-count-condition/m-p/1294998#M825736 vishsaggi 2017-07-12T17:06:49Z Re: Set Analysis with a count condition https://community.qlik.com/t5/QlikView/Set-Analysis-with-a-count-condition/m-p/1294999#M825738 <HTML><HEAD></HEAD><BODY><P>Don't think that will help.... what we need is to know what dimension are we doing this count on...</P></BODY></HTML> Wed, 12 Jul 2017 17:09:32 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-a-count-condition/m-p/1294999#M825738 sunny_talwar 2017-07-12T17:09:32Z Re: Set Analysis with a count condition https://community.qlik.com/t5/QlikView/Set-Analysis-with-a-count-condition/m-p/1295000#M825740 <HTML><HEAD></HEAD><BODY><P>Got it. Thanks Sunny...</P></BODY></HTML> Wed, 12 Jul 2017 17:16:58 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-a-count-condition/m-p/1295000#M825740 vishsaggi 2017-07-12T17:16:58Z