-
1. Re: Substituting 0 when we 'Show Empty Rows' option ?
Fred Leal Oct 24, 2014 2:58 PM (in response to tholkappian.vadivelu)1 of 1 people found this helpfulHello
here is something you could try, do some format to the field
go to special values, and add 0, it may give you what you looking for
cheers
-
2. Re: Substituting 0 when we 'Show Empty Rows' option ?
Palani Ramu Oct 24, 2014 3:12 PM (in response to tholkappian.vadivelu)Hello Vadivelu,
Please find the solution for Null Replacement by Zero.
1. create formula for concern measure using below formula
eg ifnull(<measure value>,0) -- here Red colour zero is replacement value when measure is null
2. create table with total & subtotal.
3. cross reference/check purpose add - original measure value also in same table .
Null replaceby0 -- is acalculated column
Sales -- Original measure column.
summary : Not required to implement customized formula, hence tableau has implemented that null replaced by 0.
Thanks
Palani
-
3. Re: Substituting 0 when we 'Show Empty Rows' option ?
tholkappian.vadivelu Oct 26, 2014 1:35 PM (in response to Fred Leal)I tried your idea but it did not work. Value is still empty.
-
4. Re: Substituting 0 when we 'Show Empty Rows' option ?
tholkappian.vadivelu Oct 26, 2014 1:40 PM (in response to Palani Ramu)Sorry. I did not get your complete solution but if you are asking me to use a calculated field wherein check for null and replace the [Number of Records] column, I did try the same like following but it's not working either.
ZN(Lookup(Sum([Number of Records]),0))
-
5. Re: Substituting 0 when we 'Show Empty Rows' option ?
tholkappian.vadivelu Nov 13, 2014 1:23 PM (in response to tholkappian.vadivelu)Did I not make it clear or something ? I thought it would be a simple solution but could not get it to work and more surprisingly no solutions from the group. Do I need to add more info from my part ?
Thanks
-
6. Re: Substituting 0 when we 'Show Empty Rows' option ?
Tableau kumar Nov 14, 2014 3:51 AM (in response to tholkappian.vadivelu)we can use the following ways to replace nulls
1) zn([sales])
2) if( isnull([Sales]), "Null", [Sales]))
3) As Ramu attached a screen shot
Best Regards
Laxman Kumar
-
7. Re: Substituting 0 when we 'Show Empty Rows' option ?
Marcin Borowik Dec 9, 2015 6:49 AM (in response to Tableau kumar)Hello,
Do you have any update, please ?
It is very inconvenient for the client to have blank cell instead of 0 value.
Marcin
-
8. Re: Substituting 0 when we 'Show Empty Rows' option ?
Ben Lay Jun 23, 2016 6:56 AM (in response to tholkappian.vadivelu) -
9. Re: Substituting 0 when we 'Show Empty Rows' option ?
Scott Kailey Jul 11, 2016 9:50 AM (in response to tholkappian.vadivelu) -
10. Re: Substituting 0 when we 'Show Empty Rows' option ?
Swarup K Jul 11, 2016 10:09 AM (in response to Scott Kailey)Hi Scott,
Use the below formula to show 0, when there is a null or for a blank record in the database.
ZN(LOOKUP(SUM([value],0)))
If you still have problem,attach the workbook.
Regards
Swarup.
-
11. Re: Substituting 0 when we 'Show Empty Rows' option ?
Scott Kailey Jul 11, 2016 10:37 AM (in response to Swarup K)Hi Swarup.
I have tried this with no luck. I am using the example workbook as a reference from this thread.
Re: Setting null values to zero
However, when I create that calculation and drag it over, it doesn't work. I have noticed that it changes from calculating across the table to down the table. I am not sure if that is affecting it or not. Also, the difference between mine and the example is that i have sub-groups under the main group.
Unfortunately, I can't attach the workbook because it is large with proprietary data in it. Here are some screenshots of what I am talking about. Maybe that will help.
-
12. Re: Substituting 0 when we 'Show Empty Rows' option ?
Swarup K Jul 11, 2016 11:25 AM (in response to Scott Kailey)Hi Scott
Just small change in the formula you are referring workbook. Open in 9.3.
Replace the logic according to your requirements, let me know if you still have any issue.
-
Zero Nulls Eg_RL.twbx 368.4 KB
-
-
13. Re: Substituting 0 when we 'Show Empty Rows' option ?
Scott Kailey Jul 11, 2016 11:36 AM (in response to Swarup K) -
14. Re: Substituting 0 when we 'Show Empty Rows' option ?
Swarup K Jul 12, 2016 10:02 AM (in response to Scott Kailey)