3 Replies Latest reply on Jan 28, 2018 7:10 PM by Zhouyi Zhang

ISNULL shows as a value other than NULL

Brian Fornelius Jan 17, 2018 3:27 PM

Hi there,,,

I am Joining a Excel file to a MYSql database and am wondering something.

the excel file list a group of Hotel propeties that are preferred which I have set up as a column in the excel file. However if I try to create a report to show all other properties (not the ones from the Excel file) I use ISNULL but the column shows NULL. instead of Preferred. Is there a way to have them show as Non-Preferred' in the column?

Kind of like in SQL when you would say and c.hotelname AS 'Hotel'

Thanks.

1. Re: ISNULL shows as a value other than NULL

Zhouyi Zhang Jan 17, 2018 10:02 PM (in response to Brian Fornelius)

Hi, Brian

Can you show some sample data from both Excel and MYSQL as well as how you do the join?

ZZ
Like Show 0 Likes(0)

Actions
2. Re: ISNULL shows as a value other than NULL

Brian Fornelius Jan 24, 2018 8:23 AM (in response to Zhouyi Zhang)
the data works... I'm just trying to figure out how to get it to display inthe summary differet.

{FIXED : MAX(
IF = 1
AND ISNULL()
THEN ()
ElSE NULL
END
)}

I have the above and then the oppposite where contact = 1. How I want it to display in the reports is a 'Y' or 'N'

For the ones that are ISNULL I would like it to show 'N' instead of Null. and for the ones where contract = 1 I would like it to display as 'Y'

So the output of the below would have a 'N' instead of Null..

Sent from Outlook<http://aka.ms/weboutlook>

image.png 3.5 KB
Like Show 0 Likes(0)

Actions
3. Re: ISNULL shows as a value other than NULL

Zhouyi Zhang Jan 28, 2018 7:10 PM (in response to Brian Fornelius)

Hi, Brian

I am not quite sure what are you talking about your formula and you screenshot just doesn't have enough information to help. but general speaking, you can always try below

if isnull(your measure) then "N" else "Y" end

Hope this could help

ZZ
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

ISNULL shows as a value other than NULL

1. Re: ISNULL shows as a value other than NULL

2. Re: ISNULL shows as a value other than NULL

3. Re: ISNULL shows as a value other than NULL

Sign In or
Create your Account

Actions

More Like This

Sign In or Create your Account

Sign In or
Create your Account