Qlik Community

Qlik Sense App Development

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

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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 (5)
1 Solution

Accepted Solutions
Highlighted
MVP
MVP

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
Highlighted
MVP
MVP

Would you need script solution or front end?

Highlighted
MVP
MVP

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