How to set multiple values for parameters with Navigate Action

[aswilson]

It is currently possible to set multiple default values from a datasource field with items in a simple csv formatted list e.g. “id1,id2,id3,id4,…”

It is also possible to update using Navigation Action set to Custom and providing item values each on a separate line like this:

However, if I try to update using a Navigation Action set to a field value containing the same CSV item list used to set the parameter defaults it fails. Instead it loads the entire csv string as one value.

I have tried: adding line feed as in “item1/nitem2/nitem3/n”. this pivots the value to a column, but still assigns the whole column to the first value.

Is there a way to populate multiple values from a field value during a Navigation Action in the same way you can populate multiple values from a field as the dynamic default?

[aswilson]

I have discovered that if I set the parameter input control to text input multi-line and set “Separate Values by” to comma, then the Navigation Action will populate my CSV list into the parameter control. However, it still doesn’t update the parameter until I put the cursor in the parameter control list and hit Enter.

That seems to match this archived bug ticket from November 2023.
Is this still a known bug? Is there a workaround?

Navigation Action with comma delimited field to multi parameter: No Data

I have a table with a field that contains a list of products, separated by comma (it’s a calculated field, so I can separate them by whatever if needed per the provided solution). On this table I have a number of navigation actions, one of which takes this field of comma separated products and send the user to another tab for a deep dive and puts that field in a parameter. It’s a multi value string parameter, and the control for it is set to comma separated. When the navigation action moves to t…

[royyung]

@aswilson, not sure if I get it wrong, I can’t reproduce the same case you mentioned.
I am sharing a testing dashboard in Arena multiValueParameter

can see if it is what you want? or can you share a sample? thanks

[aswilson]

Hi @royyung. Thanks so much for taking the time to look at t his issue and create the arena dashboard. Unfortunately that’s not the issue I have. Populating a single value using the Navigation Action works fine. My issue is populating multiple values using a string with comma-separated values (or line feeds, or pipes, etc.). I have created a dashboard to show the issue here: multiValueParameter - navigation update

[royyung]

thanks @aswilson for sharing the example. it is very heplful

I see this whole process need to handle 2 steps

1. when user choose the list of items, the parameter need to be updated. this step was succeed as the values were updated in the list control
   

   

2. In the 2nd step, the value of calculated field “In List Flag” needs to be updated after parameter value has updated.
   

   

So that this calculated field can be used in the filter of the table on the most right hand side

However, the value of calculated field will not be updated until user manually click enter in the filter control.

I will tag this as a feature request.

[aswilson]

@royyung thank you for your response. I understand you will list this as a feature request, but per the other ticket I attached above, this was identified by the team as a bug in November 23rd, which I take as indication that it should work without an additional click on the parameter control. Do you know the status of this bug and when or if a fix will be delivered?

[rssawers]

I still have not heard back on this one. Hope you get traction on it now!

[Brett]

Hi @aswilson,
It’s been awhile since last communication on this thread, so following up. As QuickSight does not disclose their current roadmap or timing, we’re unaware of any status on this bug fix/feature request. You can keep an eye out on new implementations through the ‘What’s New’ section of the community.

Thank you!