Dynamically changing the Values of Parameter

Q&A
,
1

Hi everyone,

I’m trying to set up a dynamic visual in Quick Sight, but I’ve hit a roadblock with the rule-based hiding feature. Here’s the scenario:

  • I have a table with the following columns: Category, Subcategory, Product ID, and Order Value.
  • When I select a Category (like Clothing), it filters the data down to specific subcategories, for example, Shirts and Pants, along with their respective product IDs and order values.
  • Now, I want the visual to show up only when the Subcategory is equal to Pants and the Product ID is 00121. If those conditions aren’t met, the visual should remain hidden.

However, the rule-based hiding feature in Quick Sight supports field parameters conditions, but it doesn’t seem to allow for field-level conditions. Essentially, it doesn’t support multiple conditions simultaneously (e.g., checking both the Subcategory and Product ID together). From what I can see, it only supports checking one condition at a time.

I’m wondering if anyone has encountered a similar situation and found a workaround? Is there a way to replicate this behavior in Quick Sight without directly involving the fields? Also, does anyone know if it’s possible to have multiple conditions in a rule-based hiding? If not, would this be something we could suggest as a feature request in the future?

Thanks in advance for your thoughts and suggestions!

2

I don’t think there is super elegant solution to this. It’s a good feature request.

As a workaround you could use filter actions like below. Where a list of product Ids would set a concat value of the cat and product id.

Here’s a gallery example.

dynamically-changing-the-values-of-parameter/44301

image
image1321×930 9.89 KB

image
image1823×817 16.3 KB

3

Hi @robdhondt,
Thank you for your response. But my requirement involves rule based hiding based on a field condition and this workaround doesn’t satisfy it.

But I have implemented a workaround for it by creating separate parameters for all the visuals with controls and that controls would be giving the user to choose whether that particular visual needs to be printed along with the other shown visuals.

Thanks