Dynamic Dimensions for a Scatter Chart

shilunannan · ‎2022-01-04

Hi All,

Many thanks in advances!

I have a data frame as below and I want to plot a scatters plot, where I could assign x and y axis dynamically with column headers. For example, select column a for x-axis and column e for y-axis.

a	b	c	d	e	f	g	h	i
26	96	90	52	32	84	60	83	95
66	15	56	62	58	42	58	19	88
43	68	73	98	97	66	27	99	77
61	17	67	72	10	41	29	98	37
23	72	20	59	92	99	94	85	36
78	20	66	79	36	76	99	43	32
47	47	29	14	57	62	8	76	35
18	48	33	63	34	23	16	39	60
14	22	69	51	61	72	82	88	27
66	30	76	89	16	64	49	51	86
63	52	3	20	49	21	46	88	2
7	1	88	6	29	39	55	49	42
28	21	31	34	83	68	15	56	22
2	31	40	49	90	77	82	47	21
43	4	1	73	63	57	66	60	39
89	1	15	76	58	52	62	3	9
35	40	74	11	54	19	44	84	26
35	66	90	89	10	37	33	62	29
72	93	96	6	59	76	6	31	30
89	45	54	55	86	29	67	71	15
3	34	55	9	56	35	32	79	78
61	49	74	36	18	84	37	26	21
52	84	65	8	83	49	23	13	60
44	92	34	20	8	47	48	59	34
94	55	39	50	97	6	70	28	76
62	40	22	38	82	71	66	2	24
35	75	38	0	57	8	16	94	50
60	76	48	43	16	27	64	80	93
29	98	13	23	82	37	15	86	21
22	96	57	39	2	11	3	83	12

Thanks

AshutoshBhumkar · ‎2022-01-05

Hello,

You can use Input box/Drop down/Buttons and variables to enter and pass the values into the chart.

Create two buttons/Drop downs for x and y axis.

shilunannan · ‎2022-01-05

Thanks! Could you please share an example? I'm very new to the qliksense.

Thanks a lot

AshutoshBhumkar · ‎2022-01-05

Hello,

You can refer below video link to understand the example.

https://www.youtube.com/watch?v=w5dTLv8XU50

Hope this helps.

Thanks,

Ashutosh

Community Help

Other

Qlik Sense

a	b	c	d	e	f	g	h	i
26	96	90	52	32	84	60	83	95
66	15	56	62	58	42	58	19	88
43	68	73	98	97	66	27	99	77
61	17	67	72	10	41	29	98	37
23	72	20	59	92	99	94	85	36
78	20	66	79	36	76	99	43	32
47	47	29	14	57	62	8	76	35
18	48	33	63	34	23	16	39	60
14	22	69	51	61	72	82	88	27
66	30	76	89	16	64	49	51	86
63	52	3	20	49	21	46	88	2
7	1	88	6	29	39	55	49	42
28	21	31	34	83	68	15	56	22
2	31	40	49	90	77	82	47	21
43	4	1	73	63	57	66	60	39
89	1	15	76	58	52	62	3	9
35	40	74	11	54	19	44	84	26
35	66	90	89	10	37	33	62	29
72	93	96	6	59	76	6	31	30
89	45	54	55	86	29	67	71	15
3	34	55	9	56	35	32	79	78
61	49	74	36	18	84	37	26	21
52	84	65	8	83	49	23	13	60
44	92	34	20	8	47	48	59	34
94	55	39	50	97	6	70	28	76
62	40	22	38	82	71	66	2	24
35	75	38	0	57	8	16	94	50
60	76	48	43	16	27	64	80	93
29	98	13	23	82	37	15	86	21
22	96	57	39	2	11	3	83	12

a	b	c	d	e	f	g	h	i
26	96	90	52	32	84	60	83	95
66	15	56	62	58	42	58	19	88
43	68	73	98	97	66	27	99	77
61	17	67	72	10	41	29	98	37
23	72	20	59	92	99	94	85	36
78	20	66	79	36	76	99	43	32
47	47	29	14	57	62	8	76	35
18	48	33	63	34	23	16	39	60
14	22	69	51	61	72	82	88	27
66	30	76	89	16	64	49	51	86
63	52	3	20	49	21	46	88	2
7	1	88	6	29	39	55	49	42
28	21	31	34	83	68	15	56	22
2	31	40	49	90	77	82	47	21
43	4	1	73	63	57	66	60	39
89	1	15	76	58	52	62	3	9
35	40	74	11	54	19	44	84	26
35	66	90	89	10	37	33	62	29
72	93	96	6	59	76	6	31	30
89	45	54	55	86	29	67	71	15
3	34	55	9	56	35	32	79	78
61	49	74	36	18	84	37	26	21
52	84	65	8	83	49	23	13	60
44	92	34	20	8	47	48	59	34
94	55	39	50	97	6	70	28	76
62	40	22	38	82	71	66	2	24
35	75	38	0	57	8	16	94	50
60	76	48	43	16	27	64	80	93
29	98	13	23	82	37	15	86	21
22	96	57	39	2	11	3	83	12

a	b	c	d	e	f	g	h	i
26	96	90	52	32	84	60	83	95
66	15	56	62	58	42	58	19	88
43	68	73	98	97	66	27	99	77
61	17	67	72	10	41	29	98	37
23	72	20	59	92	99	94	85	36
78	20	66	79	36	76	99	43	32
47	47	29	14	57	62	8	76	35
18	48	33	63	34	23	16	39	60
14	22	69	51	61	72	82	88	27
66	30	76	89	16	64	49	51	86
63	52	3	20	49	21	46	88	2
7	1	88	6	29	39	55	49	42
28	21	31	34	83	68	15	56	22
2	31	40	49	90	77	82	47	21
43	4	1	73	63	57	66	60	39
89	1	15	76	58	52	62	3	9
35	40	74	11	54	19	44	84	26
35	66	90	89	10	37	33	62	29
72	93	96	6	59	76	6	31	30
89	45	54	55	86	29	67	71	15
3	34	55	9	56	35	32	79	78
61	49	74	36	18	84	37	26	21
52	84	65	8	83	49	23	13	60
44	92	34	20	8	47	48	59	34
94	55	39	50	97	6	70	28	76
62	40	22	38	82	71	66	2	24
35	75	38	0	57	8	16	94	50
60	76	48	43	16	27	64	80	93
29	98	13	23	82	37	15	86	21
22	96	57	39	2	11	3	83	12