Set Analysis FieldA = FieldB

[cbushey1]

Hi there,

I am looking to do set analysis where two different date fields have the same value.

Essentially, I have a data model where I have two calendars, A, B. What I need to display in my chart is the sum of some fields from Table B and the Sum of fields from Table A, all having the dimensions of Table A.

Table A:                    TableB:

CasesCreated          ProjectedAmount

CreateDate               BudgetDate

The set expression I am trying to build is

Sum({<CreateDate = BudgetDate>} ProjectedAmount)

Ideally, this expression would return the total Projected amount where the dates are equal.

Any thoughts?

I have already tried using the above and with p() to no avail.

Thanks!

[Anonymous]

You can do an if statement with a calculated dimension and then you don't need set analysis in your expressions at all.  Oleg is right though it would be a Cartesian join that may not perform very well if you have a lot of data.

But your calculated dimension would be something like:

if (CreateDate=BudgetDate,CreateDate,'')

Then you can create your expressions normally as sum(ProjectedAmount) or whatever it may be.