topic Re: Need help with nested IFs in App Development

Need help with nested IFs

User13 — Sat, 16 Nov 2024 01:21:35 GMT

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

Employee	Supervisor
A
B	A
C	B
D	B
E	C

Re: Need help with nested IFs

edwin — Tue, 29 Sep 2020 20:38:54 GMT

Assuming you are building a chart,

this gets you all the subordinates:
= count(DISTINCT {<Employee=, Supervisor={'$(=only(Employee))'}>}Employee)

this gets the supervisor:
= count(DISTINCT {<Employee=p({<Employee={'$(=only(Employee))'}>} Supervisor)>}Employee)

you can of course extrapolate from this using concat, etc..

hope that helps

Re: Need help with nested IFs

Kushal_Chawda — Wed, 30 Sep 2020 00:10:18 GMT

@User13 try below

Create variable vEmployees on frond end with below expression

=Concat(distinct chr(39)&Employee&chr(39),',')

Then create below expression. Note that Employee and supervisors both should present in dimensions

=Count({<Employee+=p({1<Supervisor={$(vEmployees)}>}Employee)>}Employee)

You can also use the set in actual expression. Let's say you have measure as Sum(Salary) then use below

=sum({<Employee+=p({1<Supervisor={$(vEmployees)}>}Employee)>}Salary)

Re: Need help with nested IFs

Kushal_Chawda — Wed, 30 Sep 2020 00:11:39 GMT

@User13 use distinct keyword in concat function.. updated expression

Re: Need help with nested IFs

User13 — Wed, 30 Sep 2020 07:47:11 GMT

Hi Edwin,

Thanks for your reply.

I am working on Org chart and trying to create functionality to search employees by name using dropdown list. I think we have to perform this in dimension field.

Thanks

Re: Need help with nested IFs

User13 — Wed, 30 Sep 2020 07:48:10 GMT

Hi Kush,

Thanks for your reply.

I am working on Org chart and trying to create functionality to search employees by name using dropdown list. I think we have to perform this in dimension field.

Thanks

Re: Need help with nested IFs

Kushal_Chawda — Wed, 30 Sep 2020 09:46:44 GMT

@User13 As I mentioned , You can add the Dimensions in your chart (Employee & Supervisor) and then add the measure with set as I mentioned. You can provide filter of Employee to select any value.