Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
holynumbers
Contributor II
Contributor II

Discard fields table calculation?

Hi,

I'm a newbie in this world so please be patient.

This is the table object I have:

EmployeeTeamYesterdayYesterday Department
Jane DoeTeam A=(Sum({<Yesterday={1}>}numerator)/Sum({<Yesterday={1}>}denominator))
John DoeTeam B
=(Sum({<Yesterday={1}>}numerator)/Sum({<Yesterday={1}>}denominator))

I also have a flag for the department.

What I want is to make the same calculation but on the Department flag. I've looked in to the Aggr-function but didn't make it. Someone that has any suggestions?

/John

1 Solution

Accepted Solutions
holynumbers
Contributor II
Contributor II
Author

Thank you for your help and guiding me in the right direction!

Sum({<Yesterday={1}, Team=, Employee=>} TOTAL denominator)

View solution in original post

6 Replies
sunny_talwar

Would you be able to share some numerical data and the output you are looking to get out of it?

holynumbers
Contributor II
Contributor II
Author

Sure.

Employee, Team, Yesterday, Yesterday Department

Jane Doe, Team A, (5/2), (10/5)            (departmentflag = 1)

John Doe, Team B, (5/3), (10/5)            (departmentflag = 1)

James Bond, Team C, (9/6), -                    (departmentflag = 0)


Don't know if this got any clearer.

sunny_talwar

It hasn't, are you able to provide a app you are working with to help you better?

holynumbers
Contributor II
Contributor II
Author

Sorry, I can not share app due to company policy.

Lets make the problem easier instead.
In the last column I want to show the sum of the team/groups achievement.

Name, Team, Result, Team Result

John  , T1     , 5         , 8

Jane  , T1     , 3         , 8

I want the SET-formula to calculate the Team total result on each row.

I don't know I can explain it any easier.

sunny_talwar

If this is needed directly in a chart, you can try this

Sum(TOTAL <Team> Result)

holynumbers
Contributor II
Contributor II
Author

Thank you for your help and guiding me in the right direction!

Sum({<Yesterday={1}, Team=, Employee=>} TOTAL denominator)