-
1. Re: Hide NULL value in Quick Filter But not in data.
Michael Gillespie
Feb 15, 2019 6:00 AM
You could create a new calculated field based on COUNTRY and assign a real value (like UNKNOWN) to the NULLs in the data, then use that new field as your filter instead of the original COUNTRY field.
Would that work for you?
-
2. Re: Hide NULL value in Quick Filter But not in data.
No. Its not going to work for me. In-case if users Un-selects All and selects specific countries. it wont show the NULL data.
All i need is irrespective of Country filter Null data should be present in Data Pane and Filter should not have it.
-
3. Re: Hide NULL value in Quick Filter But not in data.
Michael Gillespie
Feb 15, 2019 6:14 AM
You can't use JUST a filter to get that result. A filter is simply a list of the unique values in a column in your data set. If you want to show different things in the filter, you need to create a parameter, probably. But if you need multi-select, then a parameter won't work either.
Sets and set actions, perhaps?
-
4. Re: Hide NULL value in Quick Filter But not in data.
If you can give an example that would be great!. I'm running out of ideas for this option.
-
5. Re: Hide NULL value in Quick Filter But not in data.
Michael Gillespie
Feb 15, 2019 6:34 AM
It's a hard problem. Why do you not want to show NULL in the filter? What problem does that cause?
You have to have some means of creating an arbitrary grouping of countries you want to display that forces the NULL values to display no matter what else displays, but hide the NULLs from the interface element that you're using to allow your user to select countries.
I suspect that there might be a way to do it with a set, but I don't have time at the moment to work through it.
-
6. Re: Hide NULL value in Quick Filter But not in data.
Simple Users don't want to see that Null value in drop down. It may tend to confuse the people as well. So looking for alternative solutions.
i tried with sets as well. but didn't workout for me.
