Set Analysis question

[john_duffy]

Hello.

I have attached a sample application with 3 charts that provide the same values:

1 - Expression using an if statement

2 - Expression using set analysis with -= 0

3 - Expression using set analysis with > 0

When a value for Store Type is selected, why doesn't the 3rd chart (using > 0) drill down?

Thanks,

John.

[jcampbell]

Set Analysis will not update on selections. That's the beauty of Set Analysis. So when you use Set Analysis the result of the expression should be unchanged regardless of selections made. In this case it should always display the expression results where the Store Type is > 0 AND the Store Loc = N. If you change the third Object to use the following Expression you will get the results you're looking for:

Sum({$<[Store Type] = {">0"},[Store Loc] = {"N"}>} Sales)

And this will be unchanged regardless of selections. It seems to me that the second Object needs some tweaking for the Expression. Unfortunately I'm not familiar with using -= (or NULL) in Expression or Set Analysis.

Hope the above helps.

[cesaraccardi]

Hi John,

This happens because the modifier [Store Type] = {'>0'} overwrites the selection you made previously in the same field.

Regards,

Cesar

[cesaraccardi]

When you use -= in the second chart, is the same as: [Store Type]=[Store Type]-{0}, the result is all selected store types excluding zero.

[mikecrengland · Accepted solution]

try this

Sum({$<[Store Type] *= {">0"},[Store Loc] = {'N'}>} Sales)

note the '*' after [Store Type]

[john_duffy]

Thanks for your help guys.