Set Analysis: Ignore All Selections except for one field

[Anonymous]

Is there any simple way in Set Analysis to ignore all selections, except for one field that we want the selections for ?

[sunny_talwar · Accepted solution]

May be this Bill:

{1<FieldName = $::FieldName>}

[Gysbert_Wassenaar]

{1<FieldName=P(FieldName)>}

[sunny_talwar]

Gysbert, but this can still be impacted by other field selections. Lets say I have a product (Product A) which is only available in 2 of the three years and I have an expression like this -> Sum({1<Year = p(Year)>} Sales). If now I select Product A, I will only see the data for the two years because p(Year) will be the those two years where we have sales for Product A.

[Anonymous]

Many thanks Sunny & Gysbert.  In my data scenario they both work perfectly.

[Gysbert_Wassenaar]

You're completely right. Usually the possible values are what is wanted though. That's what the user can see as selected values.

[user-azadi]

thank you sunny . great solution

but what mean $:: in your expression? i search community but not found any thing about it!

[tresesco]

@user-azadi 

Have a look at this document that I created, hope that helps in understanding it better : Ignore-all-selections-except-few-fields-using-Set-Analysis