Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

holynumbers
New 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
New Contributor II

Re: Discard fields table calculation?

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

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

6 Replies

Re: Discard fields table calculation?

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

holynumbers
New Contributor II

Re: Discard fields table calculation?

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.

Re: Discard fields table calculation?

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

holynumbers
New Contributor II

Re: Discard fields table calculation?

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.

Re: Discard fields table calculation?

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

Sum(TOTAL <Team> Result)

holynumbers
New Contributor II

Re: Discard fields table calculation?

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

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