# No value is set for the parameter, but it is not judged as NULL

**URL:** <https://community.amazonquick.com/t/no-value-is-set-for-the-parameter-but-it-is-not-judged-as-null/5618>\
**Category:** Q&A\
**Tags:** calculations, quick-sight\
**Created:** [August 26, 2022, 9:40am UTC](https://community.amazonquick.com/t/no-value-is-set-for-the-parameter-but-it-is-not-judged-as-null/5618 "2022-08-26T09:40:08Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Natsuki](https://avatars.discourse-cdn.com/v4/letter/n/d26b3c/32.png) [@Natsuki](https://community.amazonquick.com/u/Natsuki)\
**Post date:** [August 26, 2022, 9:40am UTC](https://community.amazonquick.com/t/no-value-is-set-for-the-parameter-but-it-is-not-judged-as-null/5618/1 "2022-08-26T09:40:08Z")

</div>

I want to display the value of the parameter in the title of the visual.  
I tried the following formula, but it doesn’t work.  
・If the year parameter is “Select all”, return NULL, otherwise return the year.  
`ifelse(isNull(${year1}),NULL,${year1})`

Result: If the year parameter is “Select all”(NULL), “ALL” is displayed in the title.

It seems that the `isNull(${year1})` part is not handled correctly.  
In Insight, the above formula worked well, but when I implemented it in the visual title, I couldn’t do it.  
Is NULL not set when all parameters are selected?

Please advice how to hide parameter value when parameter is “Select all”

---

<div class="post-metadata">

**Author:** ![Max](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/max/32/2288_2.png) [@Max](https://community.amazonquick.com/u/Max)\
**Post date:** [September 8, 2022, 8:42pm UTC](https://community.amazonquick.com/t/no-value-is-set-for-the-parameter-but-it-is-not-judged-as-null/5618/2 "2022-09-08T20:42:16Z")

</div>

Have you tried ifelse(${year1}=‘All’,‘’,${year1})?

A couple of things: I think the default value is All or ALL. It can be dynamically set with the newest version of quicksight.

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/2X/3/31520bf88185cca63869939f9eca7cb62019991d.png)

The other thing is that you might want to return an empty string instead of NULL.

Please let me know if that helps,

---

<div class="post-metadata">

**Author:** ![Kristin](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/kristin/32/2470_2.png) [@Kristin](https://community.amazonquick.com/u/Kristin)\
**Post date:** [September 18, 2022, 3:12am UTC](https://community.amazonquick.com/t/no-value-is-set-for-the-parameter-but-it-is-not-judged-as-null/5618/3 "2022-09-18T03:12:03Z")

</div>

Hi, @Natsuki. We hope that Max’s solution worked for you. I am marking his reply as, “Solution,” but let us know if this is not resolved.