Can I get Weighted Average in Total Row of Simple Table?

[Rich5678]

Hi,

Does Qlik have capability to show "Weighted Average" in place of a Simple Average in Total Row of a Plain Table.

Subject	Marks	Weight	Weighted Avg
Math	97	0.1	9.7
Physics	85	0.2	17
Language	75	0.3	22.5
Music	64	0.4	25.6
	80.25	1	74.8

When you look at options Totals Function in Qlik Sense, we see only the following Options in a Simple Table..

Can someone clarify, if there is a Way to get Weighted Average in that Last Row representing Totals.

Thanks

[sidhiq91 · Accepted solution]

@Rich5678 Yes you can definitely get it. Please see the code that I have written in the back end first.

NoConcatenate
Temp:
Load *,
Marks*Weight as [Weighted Avg]

Inline [
Subject, Marks, Weight
Math, 97, 0.1
Physics, 85, 0.2
Language, 75, 0.3
Music, 64, 0.4
];

Exit Script;

Please see the screen shot below for the expression used in the front end:

If this resolves your issue, please like and accept it as a solution.