Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can use Alternate State
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)
Sum({$<Field1-=>} Sales) will make The expression free of selection in Field1
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
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