topic Re: Quadrants in Scatter Plot (QlikView) in QlikView

Quadrants in Scatter Plot (QlikView)

satishkurra — Fri, 27 Apr 2018 21:36:35 GMT

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

Re: Quadrants in Scatter Plot (QlikView)

satishkurra — Sat, 28 Apr 2018 13:21:07 GMT

Some one. Please help...

Re: Quadrants in Scatter Plot (QlikView)

jwjackso — Sun, 29 Apr 2018 20:26:28 GMT

The manual way would just ask the user to select the bubbles in the quadrant and then the straight table should have the correct data.

Can you use the same formula that defines the quadrants in a set analysis expression. Create 4 buttons, each representing a quadrant. Each button has an action that assigns the formula to a variable. If the variable is empty, it does not affect the content of the scatter chart.

Sum({$<$(vQuadrant)>} Amt)

Re: Quadrants in Scatter Plot (QlikView)

satishkurra — Sun, 29 Apr 2018 23:30:31 GMT

I mentioned the manual way to user. It did not help.

They need to see the list of bottom left quadrant as Low performers in a table.

Not sure on what basis we need to capture the lower quadrant people

Re: Quadrants in Scatter Plot (QlikView)

satishkurra — Mon, 30 Apr 2018 16:17:24 GMT

Any one?

Please help

Re: Quadrants in Scatter Plot (QlikView)

vishsaggi — Mon, 30 Apr 2018 16:34:54 GMT

Can you share some sample data and your expected output? Would be easy if you share a qvw file if possible?

Re: Quadrants in Scatter Plot (QlikView)

satishkurra — Mon, 30 Apr 2018 16:45:08 GMT

Attached is the sample APP.

I need the list of Record ID's in this scatter plot falling under lower quadrant. !

Re: Quadrants in Scatter Plot (QlikView)

jwjackso — Mon, 30 Apr 2018 17:19:58 GMT

Can you do something like below. I created a straight table and set the expression to be greater than the x-axis formula and less than the y-axis formula of the scatter plot reference lines.

=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 %])

You could use a button to hide/show the straight table.

Re: Quadrants in Scatter Plot (QlikView)

satishkurra — Mon, 30 Apr 2018 17:27:39 GMT

This is fine. But we need the list of only record id's falling in lower left quadrant.

In this example, it is Record ID's 917 and 1723

Re: Quadrants in Scatter Plot (QlikView)

satishkurra — Mon, 30 Apr 2018 17:32:45 GMT

I just modified your expression as below and it worked.

Please let me know if this is fine?

=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 %])

Re: Quadrants in Scatter Plot (QlikView)

jwjackso — Mon, 30 Apr 2018 17:38:57 GMT

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 %])

Re: Quadrants in Scatter Plot (QlikView)

satishkurra — Mon, 30 Apr 2018 17:54:14 GMT

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