Avoid Filter Selection

[manideep78]

Dear Community,

I have many filters in my application. I need to avoid 10 filter selections for one chart and all the remaining filters should be applied normal. Is there a way to write in set analysis instead of mentioning FilterName1=, FilterName2=,......... in set expression?

Thanks in advance

Regards

Manideep

[MK_QSL]

You can use Alternate State

[stigchel]

If these 10 filters are from a certain table in your data model, you can use something like this to exclude all fields  from this table

//clear all fields in the Master Calendar without having to explicitly list them all.

Set vClearCalendar = "='[' & Concat({1<$Table={'Calendar'}>} $Field, ']=,[') & ']=' ";

Sum ({$<$(vClearCalendar)>} Amount)

[sujeetsingh]

Sum({$<Field1-=>} Sales) will make The expression free of selection in Field1

[manideep78]

Hi,

All fields are from same table. but except these 10 filters, I have to use all other fields from the same table.

I am looking forward to this approach.

Regards

Manideep

[manideep78]

A small '=' in set analysis solved my problem.

This link helped me: Ignore all selections except some specific fields using Set Analysis

Thanks a lot every one for your response.

Regards

Manideep