Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to create a graph for team and individual members

Hi,

I  need to create a graph which shows the % of productivity of team members and individual members for a particular month.

In the chart my dimension is month.

Expressions :

1 ) Productivity :

((Subfield(Interval(ProductionTime,'hh:mm:ss'),':',1)*60*60+

Subfield(Interval(ProductionTime,'hh:mm:ss'),':',2)*60+

Subfield(Interval(ProductionTime,'hh:mm:ss'),':',3))/(60*60))*100/(PresentDays*8)

2) Attendance :

(PresentDays*100 )/ ( [Working Days])

The graph is showing values correctly when I click on individual name, but when I click on team name it is not showing the data in chart.

Table Structure :

Table 1 : Team , IndividualName , Month

Table 2 : IndividualName, IndMonth, ProductionTime, PresentDays

I would like to get the sum of data related to each team for that month when I click on Team.

1 Reply
Not applicable
Author

Got the solution. Just providing Sum(...) will be enough.