Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
User13
Contributor
Contributor

Need help with nested if in expression

Hi,

I am trying to filter values based on selection from a drop down list in a way that if employee "B" is selected from dropdown list, table should show employee "B", his supervisor "A" and his direct reportees "C" and "D"

= IF([Supervisor ]='$(=GetFieldSelections(list))' OR [Employee]='$(=GetFieldSelections(list))'
OR [Employee]= (IF([Employee]='$(=GetFieldSelections(list))',[Supervisor ])),[Employee])

This expression is returning employee "B" and his reportees but not his supervisor 

Looks like there is some issue in this part

[Employee]= (IF([Employee]='$(=GetFieldSelections(list))',[Supervisor ]))

Can you please help to resolve this

EmployeeSupervisor
A 
BA
CB
DB
EC
Labels (2)
0 Replies