How to Create Scatter Plot

[sona_sa]

How to create Scatter Plot with attached data. Output : Count of Emp in Plot area (Bubbles)

Thanks

[mato32188]

Hi Sona,

I miss what determines the horizontal spread of values inside the Ratio Score. I was able to create scatter plot, but without mentioned horizontal spread of values inside each Ratio Score segment.

BR

m

[Dalton_Ruer]

Qlik Sense actually has 2 chart types that are like what you are showing. 

Scatter Plots accept 1 Dimension and 2 Measures. So each dot is Something and the X Axis shows 1 of Something's Values and the Y Axis shows another of somethings Values. 

A Grid Plot looks similar but it accepts 2 Dimensions and only 1 Measure. 

Both chart types would allow you to set the SIZE of the dots based on another Measure and the COLOR of the dots on yet another Measure. 

[sona_sa]

Hi,

Can you share that QVF? How you are using this data for the scatter plot?

Thanks.

[sona_sa]

Hi Mato,

Can you share that QVF? How you are using this data for the scatter plot?

Thanks.

[mato32188]

Hi Sona,

script:

tab:

LOAD
"Emp. Code",
dual("Rate Score",pick(match("Rate Score",'BE','ME','EE'),1,2,3)) as "Rate Score",
Ratio
FROM [lib://XXXXXXX/Scatter Chart.xlsx]
(ooxml, embedded labels, table is Sheet1);

Visualization:

BR

m