SET analyses disregard part of selection

[#1]

Hi all,

I have a graph (see attached qvw) where I want to show all  years, allthough  I have selected one year  because for another graph  I  want to have an  overview for the selected year, How can I make this happen? 

many thanks in advane

[swuehl · Accepted solution]

Hi,

try this as expression

=avg({<salesdate=>} aggr(sum({<salesdate=>} amount),dept,salesdate))

The set expression used {<salesdate=>} will clear your selection on that field, but will still consider your selection on department. If you need to clear selection on department, too, use

=avg({<salesdate=,dept=>} aggr(sum({<salesdate=,dept=>} amount),dept,salesdate))

or use set identifier {1} to ignore any selections:

=avg({1} aggr(sum({1} amount),dept,salesdate))

Please have a look into the manual, set analysis, too.

Regards,

Stefan

[#3]

Great it works thans a lot!!