4 Replies Latest reply on Apr 17, 2015 4:00 AM by phuviet.pham

Why Tableau automatic merge 2 cells when there is no same Data

phuviet.pham Apr 17, 2015 12:33 AM

Hi everyone,

I have the Table like the Picture. The Problem is that Tableau automatic merge 2 cells when there is not same underlying data. For example. Burkina Faso has Sale volume in 2012 of $6B and Botswana has not. But Tableau still merges Cells of these 2 countries.

This Picture just shows you Test data, i can not share my real Data because of confidential issue.

Does anybody have any Idea about this Problem? and how to solve that? Thanks.

1. Re: Why Tableau automatic merge 2 cells when there is no same Data

Sankarmagesh Rajan Apr 17, 2015 1:13 AM (in response to phuviet.pham)

it works for me.

try to change null to 0.

IIF(ISNULL([Actual] ), 0, [Actual] )
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
2. Re: Why Tableau automatic merge 2 cells when there is no same Data

phuviet.pham Apr 17, 2015 1:22 AM (in response to Sankarmagesh Rajan)

Hi Sankar,

in the Dimension i have also "-". i want to convert this String into 0. i tried
INT(IIF( Sale()="-","0",Sale()) ELSE IIF(ISNULL(Sale(),0,Sale()) )
But is was error. Can you please help me to fix this Calculation?. Thanks
Like Show 0 Likes(0)

Actions
3. Re: Why Tableau automatic merge 2 cells when there is no same Data

Sankarmagesh Rajan Apr 17, 2015 2:33 AM (in response to phuviet.pham)

Hi Try this [Calculation1]
INT(IIF( [Sales]="-","0",[Sales]) )

and then try to add zero
IIF(ISNULL([Calculation1] ), 0, [Calculation1] )

Thanks
sankar
Like Show 0 Likes(0)

Actions
4. Re: Why Tableau automatic merge 2 cells when there is no same Data

phuviet.pham Apr 17, 2015 4:00 AM (in response to Sankarmagesh Rajan)

Hi Sankar,

I tried this Calculation and it worked:
ZN(INT(IIF( [Sales]="-","0",[Sales]) ))
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Why Tableau automatic merge 2 cells when there is no same Data

1. Re: Why Tableau automatic merge 2 cells when there is no same Data

2. Re: Why Tableau automatic merge 2 cells when there is no same Data

3. Re: Why Tableau automatic merge 2 cells when there is no same Data

4. Re: Why Tableau automatic merge 2 cells when there is no same Data

Actions

More Like This