Hi, I have a multi-value parameter that I’m using to display fields in a graph. I’m using it in combination with the “in” function. something like: ifelse(in(‘Value 1’, $Multi-ValueParameter), Field1,NULL) My issue is, while it works when selecting multiple fields, once I select all the fields, …

Multi Value Parameter not working when selecting All options

ErikG December 1, 2023, 9:47am 2

Hi @EduardoMelo
could you check the following

ifelse(in(NULL, $Multi-ValueParameter), NULL , Field1)

1 Like

Ifelse - Interactive Formula Correction

Topic		Replies	Views
"Select All" in parameter leads to blank values in chart Q&A quick-sight , calculations , Business-Intelligence-Engineer	5	399	July 2, 2024
Using multivalue parameter with select all in a calculated field Q&A analysis , feature-request , quick-sight , calculations	5	1756	June 19, 2023
2-Value Multivalue Parameter, "in" function and "all selected" Q&A parameters , quick-sight , filters-controls-and-parameters , calculations	2	370	June 11, 2024
Create calculated field with multiselect parameter Q&A quick-sight , calculations , Business-Intelligence-Engineer	12	114	February 13, 2025
Multi Value Parameter won't calculate when select all Q&A formulas , parameters , error , quick-sight , filters-controls-and-parameters , calculations , Business-Intelligence-Engineer	4	26	October 9, 2024