Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
joshrussin
Creator III
Creator III

Pie Chart Help

Alright, not sure how to do this or if it's even possible, but thought I'd have to ask.

I am trying to make a pie chart that shows the MTD processed per employee by area.

Here are two different files.

piechart.PNG

piechart1.PNG

In Program_Dash, there is a field called Distribution.

In Area_EMP, there are fields called MMO Distribution, Bioventus Distribution, and ZB Distribution.

Is there any way to make these 3 in Area_EMP equal to just Distribution in Program_Dash?

I want the Dimension of the pie chart to be Program_Dash,

the formula should be:

Sum(Processed_Dash) / Sum(Actual_Emp)

while month and year = this month

0 Replies