Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
sona_sa
Creator II
Creator II

How to Create Scatter Plot

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

sona_sa_0-1617900166476.png

Thanks

Labels (1)
5 Replies
mato32188
Creator III
Creator III

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.

mato32188_0-1617909316539.png

 

BR

m

ECG line chart is the most important visualization in your life.
Dalton_Ruer
Employee
Employee

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. 

ScatterPlot.png

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

GridPlot.png

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
Creator II
Creator II
Author

Hi,

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

Thanks.

sona_sa
Creator II
Creator II
Author

Hi Mato,

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

Thanks.

mato32188
Creator III
Creator III

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:

mato32188_0-1617950323031.pngmato32188_1-1617950381526.pngmato32188_2-1617950404069.png

BR

m

 

ECG line chart is the most important visualization in your life.