Quadrants in Scatter Plot (QlikView)

[satishkurra]

Hi

I attached the sample scatter plot which compares Revenue vs GM %.

I also added quadrants.

Is there a way to get the list of bubbles from lower left quadrant into a table?

I added fast change option to straight table and asked the user to click and open the details. But no luck

Please help

[jwjackso · Accepted solution]

It is basically the same thing.  I think you would want calculations (tables or set analysis) to represent each quadrant.  The bottom left quadrant would be less than the x-axis and less than the y-axis

=sum({1<[Eng. Revenue $]={"<$(=(Max(Aggr(Sum([Eng. Revenue $]),RecordID))+Min(Aggr(Sum([Eng. Revenue $]),RecordID)))/2)"},
[Gross Margin %]={"<=$(=(Max(Aggr(Sum([Gross Margin %]),RecordID))+Min(Aggr(Sum([Gross Margin %]),RecordID)))/2)"}>}[Gross Margin %])

[satishkurra]

Out of the box what if Gross Margin % is a calculated field instead of direct field?