topic Re: Scatter Charts in QlikView https://community.qlik.com/t5/QlikView/Scatter-Charts/m-p/727215#M1081850 <HTML><HEAD></HEAD><BODY><P>maybe you can use dimension limit (show only values that are); it depends on dimension (surgeons?) and expression (first one cases?)</P></BODY></HTML> Mon, 07 Jul 2014 21:20:17 GMT maxgro 2014-07-07T21:20:17Z Scatter Charts https://community.qlik.com/t5/QlikView/Scatter-Charts/m-p/727214#M1081849 <HTML><HEAD></HEAD><BODY><P>Hello - I am new to Qlikview and I am working in displaying surgical data in a scatter plot.&nbsp; I have the chart built, but would like to limit it to the surgeons that have more than 100 cases.&nbsp; Any suggestions?</P><P></P><P>Thanks,</P><P>Josina</P></BODY></HTML> Mon, 07 Jul 2014 21:07:26 GMT https://community.qlik.com/t5/QlikView/Scatter-Charts/m-p/727214#M1081849 2014-07-07T21:07:26Z Re: Scatter Charts https://community.qlik.com/t5/QlikView/Scatter-Charts/m-p/727215#M1081850 <HTML><HEAD></HEAD><BODY><P>maybe you can use dimension limit (show only values that are); it depends on dimension (surgeons?) and expression (first one cases?)</P></BODY></HTML> Mon, 07 Jul 2014 21:20:17 GMT https://community.qlik.com/t5/QlikView/Scatter-Charts/m-p/727215#M1081850 maxgro 2014-07-07T21:20:17Z Re: Scatter Charts https://community.qlik.com/t5/QlikView/Scatter-Charts/m-p/727216#M1081851 <HTML><HEAD></HEAD><BODY><P>Dimension – Surgeons</P><P>Expressions – X is Avg Supply cost; Y is Avg Direct Cost and Z (bubble) is the sum of surgery encounters</P></BODY></HTML> Mon, 07 Jul 2014 21:48:12 GMT https://community.qlik.com/t5/QlikView/Scatter-Charts/m-p/727216#M1081851 2014-07-07T21:48:12Z Re: Scatter Charts https://community.qlik.com/t5/QlikView/Scatter-Charts/m-p/727217#M1081852 <HTML><HEAD></HEAD><BODY><P>Make your dimension a a calculated Dim:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=aggr(if(count(CaseID)&gt;100, Surgeon), <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Surgeon</SPAN>)</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></SPAN></P><P>-Rob</P><P><A class="jive-link-external-small" href="http://masterssummit.com/">http://masterssummit.com</A></P><P><A class="jive-link-external-small" href="http://robwunderlich.com/">http://robwunderlich.com</A></P></BODY></HTML> Mon, 07 Jul 2014 23:46:16 GMT https://community.qlik.com/t5/QlikView/Scatter-Charts/m-p/727217#M1081852 rwunderlich 2014-07-07T23:46:16Z Re: Scatter Charts https://community.qlik.com/t5/QlikView/Scatter-Charts/m-p/727218#M1081853 <HTML><HEAD></HEAD><BODY><P>That worked!!! Thank you Rob!</P></BODY></HTML> Tue, 08 Jul 2014 20:34:25 GMT https://community.qlik.com/t5/QlikView/Scatter-Charts/m-p/727218#M1081853 2014-07-08T20:34:25Z