Chart calculation

QlikDeveloper — Thu, 19 Feb 2015 14:48:05 GMT

Hi,

We have a dashboard where we show the data of different employees and how the logged in employee and other employees are performing.An employee(employeename is locked at the time of login) can't see the other employee's earnings for the company but they can check how the other employees are performing.

Your performance(%) = column 3(Your Performance) / column 5(Total company Earnings)

Now I need help to calculate the Others peroformance percentage.

Others Peroformance % = OthersEarnings / (Total Comapny Earnings * No of Other employees) %

Here Others employees means, only those employees who has permission to sell atleast 3(> Half of the logged in employees car type) cars out of the 5 cars.

I am facing difficulties when I am trying to check the no of car types sold by an other employee as the data is locked for the logged in employee at the time of entry to the Dashboard.Please check the test data.

Car type	Your Earnings	Your Performance %	Others Performance %	Total company Earnings
	103276	5.70%	?	1812141
Sedan	15000	15.00%	?	100000
Commercial Vehicle	230	0.03%	?	812546
SUV	85473	9.56%	?	894135
hatchback	2123	42.46%	?	5000
Luxury	450	97.83%	?	460

topic Chart calculation in QlikView

Chart calculation