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: 
aljaztoman
Contributor II
Contributor II

Displaying department results for certain employees

Hello,

I am trying to display department results only for certain employees. Please see below simplified case.

For employee Jarvis (or those, who do not have A and B values), i wish to display those sums, grouped by his DEPT. 

{5D2E2CB8-26E3-40B5-8963-7BF7B307411D}.png.jpg

How can I do this with set analysis?

Thank you in advance!

 
Labels (3)
1 Solution

Accepted Solutions
Kushal_Chawda

on frond end, create a straight table

Dimension:

Employee

Dept

Expression:

=if((sum(A)+Sum(B))=0,
sum(total <Dept> aggr(sum(A)+Sum(B),Dept)),sum(A)+Sum(B))

View solution in original post

2 Replies
Kushal_Chawda

Would you need script solution or front end?

Kushal_Chawda

on frond end, create a straight table

Dimension:

Employee

Dept

Expression:

=if((sum(A)+Sum(B))=0,
sum(total <Dept> aggr(sum(A)+Sum(B),Dept)),sum(A)+Sum(B))