how can i use multi select parameter in calculated field to implement if else condition?
I want to show multiple values selected by user inside table, to achieve this i have created parameter named as “pMDimension” and added this parameter to control named as “Multi Select Dimension“ which has values “Category”, “City” and “Country”
I am trying to create calculated field based on this parameter and trying to use below expression however Quicksight is not showing me parameter name which i created in the suggested list while creating calculated field
ifelse(${parameter_name} = ‘Category’, Category, NULL)
Hi @vibhu22oct
You should provide a default value for the parameter. I think it would then display in your calculated field for use
Regards,
Giri
2 Likes
Hi @Giridhar.Prabhu ,
I have tried to mention as default values in my parameter however I am getting below error, i tried another method however its not working
Hi @vibhu22oct
It appears you have syntactical error in the first case, an extra close bracket in the ifelse clause.
In the second case you have not used the IN the right way. Please refer to the documentation below which has examples for how to use the function.
Regards,
Giri
Hi @vibhu22oct. Did this solution work for you? I am marking this as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community Q&A Forum!
