Respect Selections Before Set Analysis Applied

[#1]

Is there a way to respect the selections made before applying the set analysis rules?

[#2]

Kristy,

The set identifiers identify what record set the set analysis is based on:

$ = the records of the current selection

1= the full set of all the records in the application

take a look at the manual for some examples

Regards,

Gordon

[#3]

I understand the use of $ and 1. However, the problem I am trying to solve is this... If my set analysis restricts to a specific filter (ie. date = 1/1/2011) and I make a date selection that is not 1/1/2011, I want my results to return null, 0, blank, or something other than the results for 1/1/2011 respecting the date selection.

[erichshiino · Accepted solution]

Hi, Kristy

In this case set analysis would be an AND operation. You can use the *=

In the following expression you get the sales acoording to user selection only if they are also from John or Peter. If you your selections does not include John or Peter you will get 0.

=

sum({<[SalesMan] *={John,Peter}>} AMOUNT)

Hope it helps!

Regards,

Erich

[#5]

Thank you. I think I can use this logic to accomplish what I need.