Using the 1 in set analysis but allowing certain selections

[Anonymous]

Hello everybody,

Does any know a way in set analysis that allows you to use the 1 identifier, but also allow user selections?

I want to calculate Sales over the full set where the Red flag = 1. I then want users to be able to select a region and this to be included.

Something like

     SUM({<1{RedFlag={1},Region={$}>}Sales)

So when a user selects a region this is included in the sum.

Any ideas?

[Anonymous · Accepted solution]

This should work:

SUM({1<RedFlag={1}, Region=P(Region)>} Sales)

Regards,

Michael

[swuehl]

I can't see what you're saying, but i have lots of fields.

You can let QV do the work to create a list of all fields to clear, have a look into:

Ignore all selections except some specific fields using Set Analysis

[Anonymous]

Thanks Michael.

I was actually using your other suggestion that you made on another post which involved using a variable and GetFieldSelections

Cheers

[Anonymous]

Understood..
My suggestion above makes sense only if you actually select a Region.  Later I thought that it is better to use a variable.  Didn't rememebr I'd answered a similar question before... 🙂