Ignore Selection

[nihhalmca]

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]

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

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

[akshatagrawal]

Hi,

Can you please share sample data and required output?

Thanks & Regards

Akshat Agrawal

[nihhalmca]

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]

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.