-
1. Re: excluding null value from quick filter drop down
Sreekanth Kasaraneni Sep 16, 2016 11:02 AM (in response to Vishal D) -
2. Re: excluding null value from quick filter drop down
Kyle Boyce Sep 16, 2016 1:44 PM (in response to Vishal D) -
3. Re: excluding null value from quick filter drop down
Rajeev Pandey Sep 17, 2016 2:37 AM (in response to Vishal D)Hi Vishal,
There are three way through which you can deal this problem.
1) Add a footnote stating " Please select the Null value along with other Values" because sometimes you cannot remove null because it will filtered the important rows
2) Remove the " Null" from the data source - Right click on data source - Edit data source Filter->Add-:> Store name -> Exclude Null
3) Just Replace the Null value by adding some useful info
Replace( Store Name Dimesnion, NULL , "No Value")
Also make sure your Quick Filter option should show the " Only Relevant Values"
-
4. Re: excluding null value from quick filter drop down
Vishal D Sep 17, 2016 4:34 PM (in response to Rajeev Pandey)Do i have to create calculated field to write this replace formula?
Replace( Store Name Dimesnion, NULL , "No Value")
Also make sure your Quick Filter option should show the " Only Relevant Values"
Where do I write this?
Also only I do 'Only relevant values' what does this option do to 'No Value'?
-
5. Re: excluding null value from quick filter drop down
Vishal D Sep 17, 2016 4:45 PM (in response to Kyle Boyce)Kyle Boyce you solution will make the filter with static list of values, I want it to be dyanmic so that it picks new values which come from database.
-
6. Re: excluding null value from quick filter drop down
Vishal D Sep 17, 2016 4:48 PM (in response to Sreekanth Kasaraneni)I dont think I want to filter at datasource since it will filter other important data due to the joins defined.
I just want to not show it as a option to select in drop down.
I tried excluding the 'null' but it still shows.
-
7. Re: excluding null value from quick filter drop down
Rajeev Pandey Sep 19, 2016 3:06 AM (in response to Vishal D)Hi Vishal,
What I am trying to say here, How you can hide the Null Values from the Quick Filter.
The simplest thing you can do Duplicate the dimension and get that in filter exclude the null. get original dimension in filter and get quick filter to show only relevant.
Removing Null Values from Filters | Tableau Software
Note: This will exclude Null from the Quick Filter which will exclude the Null Values from the view.
-
8. Re: excluding null value from quick filter drop down
Kyle Boyce Sep 19, 2016 4:56 AM (in response to Vishal D) -
9. Re: excluding null value from quick filter drop down
Vishal D Sep 19, 2016 12:03 PM (in response to Kyle Boyce) -
10. Re: excluding null value from quick filter drop down
Sreekanth Kasaraneni Sep 19, 2016 12:18 PM (in response to Vishal D)Right click on the dimension and create set
select only attributes requires and click ok dont select null while creating the set
place the set onto filter shelf
-
11. Re: excluding null value from quick filter drop down
Vishal D Sep 19, 2016 1:25 PM (in response to Sreekanth Kasaraneni)Woudnt creating a set make the list static in point of time?
What if more store names are added in database, will the set pick the new stores dynamically?
-
12. Re: excluding null value from quick filter drop down
Kyle Boyce Sep 19, 2016 1:27 PM (in response to Vishal D) -
13. Re: excluding null value from quick filter drop down
Vishal D Sep 19, 2016 2:17 PM (in response to Kyle Boyce)yes, see attached twbx - sheet 'Null Issue'
I am sure I am missing something silly, shouldn't be this difficult.
-
Sample Sales.twbx 101.4 KB
-
-
14. Re: excluding null value from quick filter drop down
Sreekanth Kasaraneni Sep 19, 2016 11:05 PM (in response to Vishal D)Yes as we are excluding only null value the rest of the values will be added by default after refresh
What if more store names are added in database, will the set pick the new stores dynamically?
Yes it will update