Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
kumar2
Contributor III
Contributor III

aggregation of data in targets

Hi All,

currently i am facing some challenges in the implementing the global target calculation with the dynamic changing resource column. Please find the attached excel for the same.

where i need to calculate the weight of the resource as well as Global Target column.

Weight=count(distinct Resources)/count(Total distinct Resources)-- I am getting the weight of the resource across the Market

When iam multiplying this with the target and for the global  

SumProduct of Target across the each 

Global---sum(Target*Weight)/Sum(Weight)

where i will get the global target.

 

I have attached the sample data

 

where Resource--Tab1 and Target which i have given in the excel

Need to calculate the Weight and Global Sheet 

1 Reply
kumar2
Contributor III
Contributor III
Author

where i need to calculate the Global Target in the  Front end.

Backend i have loaded the two sheets Resource & Target