Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Thanks Stefan this is Really Helpful and it works great.