Exclude sheet from field selection

[#1]

What is the simplest way to exclude an entire sheet from a single field's selection? Ex. All field selections in the document apply to the sheet and it's child objects as normal except for the Year field selections.

[#2]

Hi Adam, Don't put month constrain in your expression. If you don't say it

by default takes all month. Sinch you are concatenating all months values

it is only concatenate only those months which comes under selected year.

To check this put this in a text box and check what all months are getting

appended: $(=chr(39) & Concat(distinct Month, chr(39) & ',' & chr(39)) &

chr(39))

[#3]

Yep, therein lies the problem. I still need the ability for the user to select a Month on the sheet to only return qtEntCore for equivalent qtMonth(s).

salesPerson, qtMonth, qtEntCore

Joe, Jan, 50

Joe, Feb, 100

Joe, Mar, 120

etc.....

So, if the user selects Jan + Feb for Joe, it will return 150. But if no Month is selected, it would return qtEntCore for all months for Joe. I realize this a crazy way to relate the months. Ideally, they should be associated by the same field name. But I tried and tried and wasn't able to get my data model to work out that way. Hence the set analysis to return the equivalent month's value.

[rbecher]

I'm a bit late here but have you tried 'alternate states'? I think this could be a solution.

- Ralf

[#5]

Yes sir, I have.

"Thanks for the reply Celambarasn, but I have considered Alternate States. The problem is, I need all other document selections to apply to the sheet except for one field. I can't have the sheet as an island."

Thank you for the reply though.

[#6]

Hi Adam, Can you create some dummy data and create a qvw to explain your

scenario and put it here, So that I can have a look at it.

[CELAMBARASAN]

It is only possible with the use of set anlaysis then .

You need to write field exclusion in all the expressions used in that sheet.

Could you post the sample file?