topic Set Analysis Question in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Question/m-p/500570#M1144298 <HTML><HEAD></HEAD><BODY><P>Hi All, I could use a little help...</P><P></P><P></P><P>I'm trying to write a formula that will idenitify the number of "MRN's" (person identifier), for only those who have charges greater than Zero.... I have written the formula this way.... Would someone identify where i'm off?</P><P></P><P></P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P>=<SPAN style="font-size: 8pt;"><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">TransactionType</SPAN><SPAN style="font-size: 8pt;"> = {'Room Adj', 'Room Charge'}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">AcctPerAndYear</SPAN><SPAN style="font-size: 8pt;"> = {</SPAN><STRONG><EM style="color: #808080; font-size: 8pt;"><STRONG><EM style="color: #808080; font-size: 8pt;">$(=max(AcctPerAndYear))</EM></STRONG></EM></STRONG></SPAN><SPAN style="font-size: 8pt;">, {</SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;">DISTINCT</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">MRN</SPAN><SPAN style="font-size: 8pt;">}&gt;} Units) </SPAN></P><P></P></BODY></HTML> Mon, 09 Sep 2013 18:04:21 GMT 2013-09-09T18:04:21Z Set Analysis Question https://community.qlik.com/t5/QlikView/Set-Analysis-Question/m-p/500570#M1144298 <HTML><HEAD></HEAD><BODY><P>Hi All, I could use a little help...</P><P></P><P></P><P>I'm trying to write a formula that will idenitify the number of "MRN's" (person identifier), for only those who have charges greater than Zero.... I have written the formula this way.... Would someone identify where i'm off?</P><P></P><P></P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P>=<SPAN style="font-size: 8pt;"><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">TransactionType</SPAN><SPAN style="font-size: 8pt;"> = {'Room Adj', 'Room Charge'}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">AcctPerAndYear</SPAN><SPAN style="font-size: 8pt;"> = {</SPAN><STRONG><EM style="color: #808080; font-size: 8pt;"><STRONG><EM style="color: #808080; font-size: 8pt;">$(=max(AcctPerAndYear))</EM></STRONG></EM></STRONG></SPAN><SPAN style="font-size: 8pt;">, {</SPAN></P><P><SPAN style="color: #0000ff; font-size: 8pt;">DISTINCT</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">MRN</SPAN><SPAN style="font-size: 8pt;">}&gt;} Units) </SPAN></P><P></P></BODY></HTML> Mon, 09 Sep 2013 18:04:21 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Question/m-p/500570#M1144298 2013-09-09T18:04:21Z Re: Set Analysis Question https://community.qlik.com/t5/QlikView/Set-Analysis-Question/m-p/500571#M1144299 <HTML><HEAD></HEAD><BODY><P>Are you trying to mix count and sum here?</P></BODY></HTML> Mon, 09 Sep 2013 18:06:35 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Question/m-p/500571#M1144299 rbecher 2013-09-09T18:06:35Z Re: Set Analysis Question https://community.qlik.com/t5/QlikView/Set-Analysis-Question/m-p/500572#M1144300 <HTML><HEAD></HEAD><BODY><P>I believe i am...... I want a count of MRNS that have more than one unit.... hope that makes sense</P></BODY></HTML> Mon, 09 Sep 2013 18:08:56 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Question/m-p/500572#M1144300 2013-09-09T18:08:56Z