Filter List of Values in the Dimensions while Importing into the Charts

[#1]

Hi

I am trying to Filter the List of Values on a Dimension while Importing into the Chart. Is there a way in Charts that I can Pull the List of selected values by filtering the respective Values through where statement or through an Expression.

[swuehl]

There are multiple ways to limit the dimension values, like

a) Using a calculated dimension

=if( match(CountryField, 'US', 'GB'), CountryField)

also activate option 'Suppress When Value is NULL' on dimension tab.

b) Using set analysis in all your chart expression

e.g. having a chart with dimension CountryField, and you want to sum a Value:

=sum({<CountryField = {US,GB}>} Value)

c) Using dimension limits (available since QV11), filter dimension by condition on first expression result

Hope this helps,

Stefan

[#3]

Thanks Stefan this is Really Helpful and it works great.