How to create scatter chart

[#1]

Hi All,

I have the following data. Based on that data how to develop scatter chart. I am using Qlikview Personal Edition,Don't send QVW file.. Please share here what is the Dimension and expressions other wise if it is possible to you share scree shots.

Inns	Date	Opposition	Ground	Runs	Mins	Balls Faced	4s	6s	Strike Rate	Batting Position	Dismissal	Match
1	16 Mar 12	Bangladesh	Dhaka	114	205	147	12	1	77.55	2	caught	462
1	13 Mar 12	Sri Lanka	Dhaka	6	25	19	1	0	31.57	2	caught	461
1	30 Mar 11	Pakistan	Mohali	85	160	115	11	0	73.91	2	caught	452
1	20 Mar 11	West Indies	Chennai	2	4	4	0	0	50	2	caught	450
1	12 Mar 11	South Africa	Nagpur	111	184	101	8	3	109.9	2	caught	449
1	27 Feb 11	England	Bangalore	120	170	115	10	5	104.34	2	caught	446
1	19 Feb 11	Bangladesh	Dhaka	28	46	29	4	0	96.55	2	run out	445
1	15 Jan 11	South Africa	Johannesburg	24	78	44	2	0	54.54	2	bowled	444
1	24 Feb 10	South Africa	Gwalior	200	226	147	25	3	136.05	2	not out	442
1	21 Feb 10	South Africa	Jaipur	4		5	1	0	80	2	run out	441

Regards

sharath

[Gysbert_Wassenaar]

A scatter chart needs at least two expressions (one for each axis) and one dimension. Any field can be the dimension, but using one of the measure fields probably doesn't make much sense. Perhaps Match is the best candidate for the dimension. For the expressions you can use any two of the measure fields. Sum(Runs) and Sum(Mins). Pick whatever two measures you want to analyse the correlation between.

[Peter_Cammaert]

Or Date combined with Opposition as a calculated dimension instead of Match.

[maxgro]

you can read this for some help on creating a scatter chart

Recipe for a Scatter Chart