This content has been marked as final.
Show 5 replies
-
1. Re: How to create a dropdownlist without null value
Deepak RaiNov 21, 2018 2:54 PM (in response to Penn Wang)
1 of 1 people found this helpful- Create a Set and Exclude Null
- Drag That Set to Filter replacing Your Original Filter
- Show Filter
Thanks
Deepak
-
2. Re: How to create a dropdownlist without null value
Jennifer VonHagel Nov 21, 2018 2:58 PM (in response to Penn Wang)1 of 1 people found this helpfulHi Penn,
You can duplicate the Date Column, and in the duplicate set the filter to Exclude Null. This will allow subsequent dates to roll in with data refreshes.
Then Put the original Date field in the Filter box and show this one to users for selection. When you show the Quick Filter, be sure to set it to "Only Relevant Values".
Best,
Jennifer
-
3. Re: How to create a dropdownlist without null value
Deepak RaiNov 21, 2018 2:59 PM (in response to Penn Wang)
-
Set to Remove Nulls.twbx 7.3 KB
-
-
4. Re: How to create a dropdownlist without null value
Deepak RaiNov 21, 2018 3:03 PM (in response to Penn Wang)
-
Set for Nulls.twbx 7.4 KB
-
-
5. Re: How to create a dropdownlist without null value
Penn Wang Nov 21, 2018 3:05 PM (in response to Jennifer VonHagel)thanks very much, works fine for me!