topic Scatter Plot Zoom Quartile in QlikView

Scatter Plot Zoom Quartile

NickHoff — Mon, 14 Nov 2016 18:34:40 GMT

Hello,

I have the following expressions:

Cost Per Case = SUM(SupplyChainLUOMTotalCost)/COUNT(DISTINCT SurgicalCaseSk)

Volume = COUNT(DISTINCT SurgicalCaseSk)

One dimension of SurgeonName

My scatter plot has the reference line at fractile 50, which displays as the following:

I'm trying to make it when the user clicks a single point in the scatter plot the chart zooms in to only the quartile the point falls in. However, if the user selects a range of points it will zoom in to only those points.

Re: Scatter Plot Zoom Quartile

NickHoff — Mon, 14 Nov 2016 22:07:53 GMT

I've been playing with the static min max expressions and I have it where the x & y doesn't change using the following. I'm guessing to get into the quartiles it will be something similar with a nested if statement.

X-Axis:

Static Min

=MIN(TOTAL {1<ProcGroup=$::ProcGroup>} AGGR(SUM({1<ProcGroup=$::ProcGroup>}SupplyChainLUOMTotalCost)/SUM({1<ProcGroup=$::ProcGroup>}Cases),ProcGroup,ProcedureSurgeonName))-1000

Static Max

=MAX(TOTAL {1<ProcGroup=$::ProcGroup>} AGGR(SUM({1<ProcGroup=$::ProcGroup>}SupplyChainLUOMTotalCost)/SUM({1<ProcGroup=$::ProcGroup>}Cases),ProcGroup,ProcedureSurgeonName))-1000

Y-Axis:

Static Min

=MIN(TOTAL {1<ProcGroup=$::ProcGroup>} AGGR(SUM({1<ProcGroup=$::ProcGroup>}Cases),ProcGroup,ProcedureSurgeonName))-20

Static Max

=MAX(TOTAL {1<ProcGroup=$::ProcGroup>} AGGR(SUM({1<ProcGroup=$::ProcGroup>}Cases),ProcGroup,ProcedureSurgeonName))-20

Re: Scatter Plot Zoom Quartile

MarcoWedel — Tue, 15 Nov 2016 00:08:09 GMT

please post a sample qvw to test with.

thanks

regards

Marco