topic Re: Ignore Selection in App Development

Ignore Selection

nihhalmca — Wed, 06 Oct 2021 09:31:10 GMT

Hi All,

I need to ignore one selection for particular chart/filter pane.

For instance : I have a table chart with columns - salesperson, address, contact, priority, product

Selections: Year = 2021, Qtr = Q2, Priority = All (need to ignore this filter above table)

I tried with set analysis like only({<priority=>} salesperson) - it returns only one value however there is a possibility

to have more than one product, contact for salesperson.

Hope I shared enough information. Thank you

stevejoyce — Tue, 28 Sep 2021 08:52:02 GMT

If you have multiple salesperson per row you can use concat to display all the values in single cell:

concat(distinct {<priority=>} salesperson, ', ')

akshatagrawal — Tue, 28 Sep 2021 09:15:40 GMT

Hi,

Can you please share sample data and required output?

Thanks & Regards

Akshat Agrawal

nihhalmca — Wed, 06 Oct 2021 09:35:59 GMT

Hi Steve - Thanks for your response, its helpful.

However its not working for filter pane. For instance I have 2 filter panes 1. Product 2. Region

When user select region = all that selection has to ignore product filter pane (no impact).

stevejoyce — Wed, 06 Oct 2021 13:13:54 GMT

That sounds like a different requirement you are looking for.

Natively, associated tables/fields in the data model will reflect based on your filters. The 2 ways to avoid this are:

1) create a table that is not associated to your data model (island table)

2) use alternate states

Either of those will have filter selections that do not get impacted by other field selections in your data model.