Tableau - How to replace null with blank or zero using ISNULL function || ISNULL function explained

Published: 23 February 2018
on channel: Tableau Tip

30,971

ISNULL function in Tableau:

ISNULL is a boolean function. Meaning it
returns TRUE or FALSE

SYNTAX: ISNULL(exp1)

It returns true if the exp1 is null
else returns false

Using this function lets replace null
with blanks or string

eg1: exp1 of datatype string
Replace null with NA:
---------------------
if ISNULL([Sub-cateogry])=TRUE then 'NA'
ELSE [Sub-cateogry] END

Replace null with blank:
-----------------------
if ISNULL([Sub-cateogry])=TRUE then ''
ELSE [Sub-cateogry] END

//here keeping =true is optional

eg2: exp1 of datatype int

Lets replace blank in Profit with 0

if ISNULL([Profit]) then 0
ELSE [Profit] END

Watch video Tableau - How to replace null with blank or zero using ISNULL function || ISNULL function explained online without registration, duration hours minute second in high quality. This video was added by user Tableau Tip 23 February 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 30,97 once and liked it 8 people.

117,30

4.8K