How to select data displayed in xy plot without affecting calculations
I have an xy scatter plot with several hundred points. The x and y positions of the points are determined by aggregation over the entire set of values in the QV document. I want to show subsets of the points without affecting the aggregation. How can I do this?
I have tried using set analysis to indicate that selections in certain dimensions should be ignored in the aggregation. This works fine for making sure the aggregation is across all data, the selections in those dimensions are also ignored in displaying the data. What I need is a way to ignore the selections made in the dimensions in the aggregation, but not to ignore those selections in which data are being displayed.
Re: How to select data displayed in xy plot without affecting calculations
Thanks for your suggestions. The set analysis works fine to makethe calculation ignore selections in the dimension. This is what I have done. However, when taking this approach , the selections are also being ignored in the data points that are being displayed in the xy plot.
To explain a bit more: for several products, I have the volume sold per country. I want the x-value in the xy plot to be the total volume of the product sold in all countries. For the calculation of the x-vlaue the selction in the dimension counntry needs to be ignored.The expression that Erica suggests does this. However, sometimes, I want to display only 2 or 3 countries in my xy plot (but the expression for the x-value still needs to be calculated across allcountries)! If I use the set expression, I cannot display a subset of the countries, because due to the set analysis in the expression, the display also ignores seectiosn in the dimension country.