Scatter Charts

[#1]

Hello - I am new to Qlikview and I am working in displaying surgical data in a scatter plot.  I have the chart built, but would like to limit it to the surgeons that have more than 100 cases.  Any suggestions?

Thanks,

Josina

[maxgro]

maybe you can use dimension limit (show only values that are); it depends on dimension (surgeons?) and expression (first one cases?)

[#3]

Dimension – Surgeons

Expressions – X is Avg Supply cost; Y is Avg Direct Cost and Z (bubble) is the sum of surgery encounters

[rwunderlich · Accepted solution]

Make your dimension a a calculated Dim:

=aggr(if(count(CaseID)>100, Surgeon), Surgeon)

-Rob

http://masterssummit.com

http://robwunderlich.com

[#5]

That worked!!! Thank you Rob!