topic Ignore Selection in expression, but not in for table in App Development

Ignore Selection in expression, but not in for table

Apfelbaum — Fri, 15 Nov 2024 23:43:53 GMT

Hi,

so I have the following question. I want to ignore the selection of a certain dimension in one expression, but still want that the table to be filtered for that dimension.

Following example

ID	Project	Project Lead
1	Dog	Josh; Marc
2	Cat	Sophie; Julian

So when I filter for Josh, the table looks like that

ID	Project	Project Lead
1	Dog	Josh

But I want it to look like that:

ID	Project	Project Lead
1	Dog	Josh; Marc

ID and Project are dimensions. Project Lead is a expression with Concat(Distinct ProjectLead, '; ')

When I use Set Expression and filter for Josh in ProjectLead, the whole table will not filter anymore. I used Concat({< ProjectLead = >} (Distinct ProjectLead, '; ') . This is the result:

ID	Project	Project Lead
1	Dog	Josh; Marc
2	Cat	Sophie; Julia

Anyone got an idea, how I can achieve this?

Looking forward for your input!

Re: Ignore Selection in expression, but not in for table

rubenmarin — Sat, 18 Sep 2021 09:15:42 GMT

Hi, you can try with: Concat({<Project=P(Project), [Project Lead]>} Distinct [Project Lead],';')

Re: Ignore Selection in expression, but not in for table

Apfelbaum — Tue, 28 Sep 2021 09:30:25 GMT

Hey, thank you very much for your solution! It works! I did not even know that there is a function P() in the setexpression! 🙂

I also found an alternate solution, which is to concat in a seperate field in the script. And then in the dashboards, in the tables you can use the concatenated field of the script, and for the filters you use the non-concatenated field.