Use a row value as field name in the set analysis for calculating avg

[prananellutla]

Hi I have 2 standalone tables and i need to show row values as metics in set analysis- how can we write this a set analysis.

I need to show metric col.

col 1	col 2	col 3	Metric
1	a	xyz	avg(xyz)
3	b	fre	avg(fre)
4	c	hyt	avg(hyt)
5	d	huy	avg(huy)
6	e	kui	avg(kui)

xyz	fre	hyt	huy	kui
13	67	6	76	4
4	90	8	34	6
5	56	23	1	7
76	45	12	34	8
3	12	6	2	3

[Mark_Little · Accepted solution]

HI @prananellutla 

You will need to build some form of link in the data model. If looks link you will need to look at the crosstable function, This will allow you to link the Col 3 to second table.

[prananellutla]

Thanks Mark for the suggestion  I read this documentation in qlik help . I will give it a try. 

https://help.qlik.com/en-US/sense/August2022/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefix...