topic Re: 2 counts in one expression - set analysis? in QlikView https://community.qlik.com/t5/QlikView/2-counts-in-one-expression-set-analysis/m-p/444607#M1165017 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>You use two sets instead of one, try this:</P><P>=count({&lt;Run_Number = {$(=Max(Run_Number))},<STRONG style="text-decoration: line-through;">&gt;}{&lt;</STRONG>[Breach graph wait band]={'52 +'}&gt;}[Breach graph wait band])</P></BODY></HTML> Wed, 26 Sep 2012 14:55:28 GMT whiteline 2012-09-26T14:55:28Z 2 counts in one expression - set analysis? https://community.qlik.com/t5/QlikView/2-counts-in-one-expression-set-analysis/m-p/444606#M1165016 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am looking to use set analysis to count people waiting over 52 weeks from my latest run of data and show this in a text box.</P><P></P><P>I have got this far</P><P><SPAN style="color: #ff0000;">=<EM>Max({&lt;Run_Number = {$(=Max(Run_Number))}&gt;}[PTL Weeks Waited])</EM></SPAN></P><P>This gets the maximum run number</P><P></P><P><SPAN style="color: #ff0000;"><EM>=count({&lt;[Breach graph wait band]={'52 +'}&gt;}[Breach graph wait band])</EM></SPAN></P><P>This gets people over 52 weeks</P><P></P><P>I am looking for a way of putting these two expressions into one to only bring back all patients over 52 weeks for the latest run month only.</P><P></P><P>I have tried</P><P><SPAN style="color: #ff0000;"><EM>=count({&lt;Run_Number = {$(=Max(Run_Number))}&gt;}{&lt;[Breach graph wait band]={'52 +'}&gt;}[Breach graph wait band])</EM></SPAN></P><P>This counts all patients over 52 weeks but ignores the run number!</P><P></P><P>This is my first post and any help would be greatly appreciated.</P><P></P><P>Thanks in advance</P><P></P><P>Mike</P></BODY></HTML> Wed, 26 Sep 2012 14:18:02 GMT https://community.qlik.com/t5/QlikView/2-counts-in-one-expression-set-analysis/m-p/444606#M1165016 2012-09-26T14:18:02Z Re: 2 counts in one expression - set analysis? https://community.qlik.com/t5/QlikView/2-counts-in-one-expression-set-analysis/m-p/444607#M1165017 <HTML><HEAD></HEAD><BODY><P>Hi.</P><P>You use two sets instead of one, try this:</P><P>=count({&lt;Run_Number = {$(=Max(Run_Number))},<STRONG style="text-decoration: line-through;">&gt;}{&lt;</STRONG>[Breach graph wait band]={'52 +'}&gt;}[Breach graph wait band])</P></BODY></HTML> Wed, 26 Sep 2012 14:55:28 GMT https://community.qlik.com/t5/QlikView/2-counts-in-one-expression-set-analysis/m-p/444607#M1165017 whiteline 2012-09-26T14:55:28Z Re: 2 counts in one expression - set analysis? https://community.qlik.com/t5/QlikView/2-counts-in-one-expression-set-analysis/m-p/444608#M1165018 <HTML><HEAD></HEAD><BODY><P>Hey whiteline Thanks for replying so quickly,</P><P></P><P>Unfortunately this shows no data and I know there were 7 people over 52 weeks.</P><P></P><P>=count({&lt;Run_Number = {$(=Max(Run_Number<STRONG>))},<STRONG style="text-decoration: line-through;">&gt;}{&lt;</STRONG>[</STRONG>Breach graph wait band]={'52 +'}&gt;}[Breach graph wait band])</P><P></P><P>It doesnt seem to like the first comma, However if I remove the comma it continues to ignore the run number.</P><P></P><P>Thanks for looking at this for me its my first day using Qlik View and its turning out to be a long one!</P><P></P><P>MIke</P></BODY></HTML> Wed, 26 Sep 2012 15:09:00 GMT https://community.qlik.com/t5/QlikView/2-counts-in-one-expression-set-analysis/m-p/444608#M1165018 2012-09-26T15:09:00Z Re: 2 counts in one expression - set analysis? https://community.qlik.com/t5/QlikView/2-counts-in-one-expression-set-analysis/m-p/444609#M1165019 <HTML><HEAD></HEAD><BODY><P>Add the quotes also:</P><P>=count({&lt;Run_Number = {<STRONG>'</STRONG>$(=Max(Run_Number))<STRONG>'</STRONG>}, [Breach graph wait band]={'52 +'}&gt;}[Breach graph wait band])</P></BODY></HTML> Wed, 26 Sep 2012 15:18:15 GMT https://community.qlik.com/t5/QlikView/2-counts-in-one-expression-set-analysis/m-p/444609#M1165019 whiteline 2012-09-26T15:18:15Z Re: 2 counts in one expression - set analysis? https://community.qlik.com/t5/QlikView/2-counts-in-one-expression-set-analysis/m-p/444610#M1165020 <HTML><HEAD></HEAD><BODY><P>Whiteline</P><P></P><P>That worked perfectly.&nbsp; Thank you so much for your help today, very much appreciated.</P><P></P><P>Mike</P></BODY></HTML> Wed, 26 Sep 2012 15:21:56 GMT https://community.qlik.com/t5/QlikView/2-counts-in-one-expression-set-analysis/m-p/444610#M1165020 2012-09-26T15:21:56Z Re: 2 counts in one expression - set analysis? https://community.qlik.com/t5/QlikView/2-counts-in-one-expression-set-analysis/m-p/444611#M1165021 <HTML><HEAD></HEAD><BODY><P>Whiteline</P><P></P><P>That worked perfectly.&nbsp; Thank you so much for your help today, very much appreciated.</P><P></P><P>Mike</P></BODY></HTML> Wed, 26 Sep 2012 15:22:04 GMT https://community.qlik.com/t5/QlikView/2-counts-in-one-expression-set-analysis/m-p/444611#M1165021 2012-09-26T15:22:04Z