topic Re: Need help on calculation below in QlikView

Need help on calculation below

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

country	Sum of col 1	Max of col 2	Max of col 3 in %	Max of col2 * col3	sum of col1/(Max of col2 *col 3)	sum of col1/max of col2	if avg sum of col1/(Max of col2 col 3) -sum of col1/(Max of col2 col 3) >5% then col1/max of col2
Africa	51	-	87%	-
London	994	6,396	87%	5,570	18%	16%
Phoneix	227	3,043	87%	2,650	9%	7%	9%
New York	1,779	8,161	87%	7,107	25%	22%
Grand Total	3051	8161(Max)	87%(Max)	15327(Total)	17.33%(Avg)	45%(Total

I'm not able to achive the last column as in grand total they are calculating the averge of sum & max values. Can anyone help on this pls

sunny_talwar — Tue, 27 Mar 2018 14:02:15 GMT

Would you be able to provide a sample to look at this?

Anonymous — Wed, 28 Mar 2018 04:07:26 GMT

Last column calculation is based on sum of col1/(Max of col2 *col 3) (6th coulmn in above table)

Eg: 17.33-18 = -0.67 which is not >5 hence null will be displayed

17.33-9=8.33 which is >5 hence 9% is displayed in last column

Can you pls help to achieve this logic in Qlikview chart.