I got Problem about make Parameter multi value for use select show data but data I want to use is not value in field but select straight to field like switch multi field by use these field in picture to show data and I want to show it all data. What I have to do ? Please Help Me.
Hi @Sunpavit,
Welcome to Quicksight Community and thank you for posting your question!
It sounds like you want to create a parameter in Amazon QuickSight that allows you to dynamically switch between different fields to display data. If the fields you want to switch between are not distinct values in a single field but rather represent different columns or measures? Please correct me?
If yes, then you can use a combination of a parameter and calculated fields to achieve this.
Step 1 - Create parameter
Step 2 - Create calculated fields - For each field you want to switch between, create a calculated field that uses the parameter to determine which field to display. Something like this -
ifElse({Parameter} = ‘Field1’, [Field1],
ifElse({Parameter} = ‘Field2’, [Field2],
ifElse({Parameter} = ‘Field3’, [Field3], ‘’))
Step 3 - In your visuals, use the calculated fields instead of the original fields. When you change the parameter value, QuickSight will dynamically switch between the fields in the visuals.
Step 4 - If you want you can add parameter controls so that you can easily switch between the fields
I hope that helps!
Thank you,
Shravya
1 Like
use this: ifelse(), not with the ‘E’ capital.
ifelse(${test2} = ‘A’ , {A},
${test2} = ‘B’ , {B},
${test2} = ‘C’ , {C},
’ ’ ).
write this. this will solve your syntax issue. but may be not your actual requirement.
you are using multivalve parameter that cause the issue. but if you use single value parameter it will show only one line in your line chart at a time. as i mentioned above this solution did not fulfil your requirement. you can not show all the values in visual using this calculated field.
i see. then what should i do to show all value with multiple parameter?
my suggestion is use the parameter for predicted fields only and not for actual. So in this way you are able to use two lines at the same time in line chart.
The other way is bit complicated but you can try, hide/show visuals based on parameter. for this you need to add at least two visuals upside down. hide second visual by default which works with parameter(add that calculated field in it). and the first visual( with all the three values) hides itself when you change the value in control.
1 Like
i don’t understand with complicate solution can you explain more please ?
Hi @Sunpavit,
What data type is your Predicted_09feats field? If it’s not a string, that explains the syntax error. The last argument in your ifelse function is an empty string, so Predicted_09feats must also have the same data type.
You can try to replace your ’ ’ by null.
1 Like
Hello @Sunpavit !
Was @shravya , @ali or @David_Wong 's suggestions helpful or were you able to find a solution for this or do you still need help on this?
If you did find a solution could you share it or if the comments above were helpful could you mark the comment as a solution to help the community?
Hello @Sunpavit , @shravya , @ali and @David_Wong !
It has been some time since we have heard from you but we would still like to help you find a solution.
If there is not activity on this thread in 4 days this topic will be archived.