Proper format for providing multiple parameter values

[dsahu]

Hello,

Hello,

I want to create a drop-down filter from a calculated field- File Validation. This calculated field is created in the analysis.

The filters are :

File size is Greater, please check
File size small, please check
File size is good

I was able to successfully create drop down filters.

In the first screenshot, ALL shows values for all filters which is correct.
In the second screenshot, File size Greater, please check----- shows the correct.

But for others, no data.

So, I believe, its the way --wrong way we are providing Multiple parameter values. Screenshot 4. Should it be divided through a comma or. semicolon?

I provided the values—one value in single line, like below–

File size is Greater, please check
File size small, please check
File size is good

Please let me know the correct way----

[DylanM]

Hello @dsahu, I may need a little more information, but I will provide a suggestion for a work-around that should resolve the issue you are facing. First, for your parameter, set a default value. If you want All to be the default response, than type ALL_VALUES in the default box. Now, rather than filtering directly from the control values selected, lets use a calculated field that takes advantage of the in function.

in - Amazon QuickSight

ifelse(
in({File Validation}, ${MultiSelectParameter}) AND isNotNull(${MultiSelectParameter}), {File Validation},
isNull(${MultiSelectParameter}), {File Validation},
NULL
)

This function will check if the parameter value is Null, which in this case will mean select all has been chosen or the default, it will return any file validation field. Otherwise, it will check if the file validation result from that row matches one of the values returned in the multi select parameter. Then, just to be sure only proper values are returned, you can apply a custom filter based on the new calculated field, select Does Not Equal from the dropdown, leave the text box empty, and make sure exclude Nulls is selected. That should give you the result you are expecting.

I’ll mark this response as the solution, but please let me know if you have any remaining questions. Thank you!

[dsahu]

Hey @DylanM ,

I tried following your steps, however, I am facing the below issue while creating the calculated field for the parameter.

‘test’ refers to the multiparameter value.

Could you please help me with this.

For reference,

calculated field for File Validation:

ifelse(FileSizeValidation= "File size greater than threshold", "File size is Greater, please check" , FileSizeValidation = "File size less than threshold, please check" , "File size small, please check " , " File size is good")

calculated field for FileSizeValidation:

ifelse(sum(FileSizeinMB) > abs(Upperthreshold), "File size greater than threshold", sum(FileSizeinMB) < abs(Lowerthreshold) , "File size less than threshold, please check", "Good File Size" )

[DylanM]

Hello @dsahu, I see, I will correct the syntax for the function below:

ifelse(
in({File Validation}, ${test}), {File Validation},
in(NULL, ${test}), {File Validation},
NULL
)

The in syntax will need to be used to check for NULLs as well, so that should resolve the error!