Limitation of calculated field

Question & Answer
,
1

I have a dataset A with these fields.

  1. oldCountry
  2. oldCountryGroup
  3. newCountry
  4. newCountryGroup

A parameter Country Type is created with value “Old” and “New”.
2 calculated fields are created

  • selectedCountry → if “Old” is selected, take oldCountry. Otherwise, take newCountry
  • selectedCountryGroup → if “Old” is selected, take oldCountryGroup. Otherwise, take newCountryGroup

However, Calculated field cannot be used as field for parameter control.
Also, selectedCountryGroup cannot be used as Show relevant values only for selectedCountry.

Any workaround?

2

Hi @lbl,
While the exact setup that you’ve explained is not quite possible in QS, there’s a work around that could provide the same functionality.
Instead of using calculated fields to limit the returns, instead make a separate visual for each, the old countries and new countries.
You’ll still setup a parameter that defines the old or new (in my attached Arena example, I used ‘Country’ or ‘Region’).
Then setup a parameter for each as well, old and new country.

Setup a rule for both the old country and old country parameter to be hidden and to only show when ‘Old’ is selected.

  • Repeat process for ‘New’.

Take a look at the example I created with sample data in the Arena view and let me know if you have any additional questions.
Limitation of calculated field

3

Hi @Brett

Got it for the visuals.
But for Filter Control, Rules is only available when filter control is inside sheet. I want to place Filter Control at top of sheet as it is common across multiple sheets. Any idea?

Thank you.