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:
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({}numerator)/Sum({}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
Contributor II
Author

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

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

6 Replies
MVP

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

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.

MVP

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

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.

MVP

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

Sum(TOTAL <Team> Result)

Contributor II
Author

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

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