Set Analysis - keep all but selected in set analsysis

[#1]

Hi

I have a straight table with an expression that uses set analysis to restrict to certain data.

=

sum({$<[Account Code] = {'INCOME'},[Period] = {'12'}>} [YTD Budget 1]*CY_Flag)/1000

I need to stop other selections of [Account Code] from affecting this table - how do I fix it so that it only shows INCOME even if someone deselects INCOME elsewhere?

Thanks

[#2]

Hi

The expression you have created already fixes the selection of Account Code, so whatever anybody selects your expression will change any selections on Account Code to INCOME.

If you have problems with the result then I suspect that it might be related to other selections, you probably need to check that.

[#3]

Hi, thanks for replying

The chart does fix income and indeed only displays income, however elsewhere I have a select box for Account Code and when someone selects items not income, in effect deselecting income in the select box all data disappears from my chart?

Dominic

[#4]

Hi

Please see attached QVW, it should be the same sort of thing you are doing so I don't understand what your problem is.

Can you post an example of your app so I can look at it?

[#5 · Accepted solution]

Hi ,

I've just realised my mistake - I've used set analysis on the account code and I'm selecting account code description! I need to set both code and description to stop other selections effecting my chart.

Thanks for you input and example - I wouldn't have spotted the problem without them.

Dominic