{"id":10307,"date":"2018-03-08T12:52:07","date_gmt":"2018-03-08T12:52:07","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=10307"},"modified":"2025-03-01T16:02:45","modified_gmt":"2025-03-01T10:32:45","slug":"tableau-logical-functions","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/tableau-logical-functions\/","title":{"rendered":"Logical Functions | Logic Statements in Tableau"},"content":{"rendered":"

In this tableau tutorial<\/strong><\/a>, we are going to study about Tableau Logical functions and different logic statements with examples that we can perform in Tableau. So, let us start tableau Logical Functions.<\/p>\n

Tableau Logical Functions<\/h3>\n

An operator could be an image that tells the compiler to perform specific mathematical or logical manipulations. Tableau encompasses a variety of operators accustomed to calculated fields and formulas.
\nRead about Tableau Paged Workbook & Steps to Create it<\/strong><\/a><\/p>\n

The basic logical statements in tableau are as follows:<\/strong><\/p>\n

a. CASE Statement<\/h4>\n

CASE expression once value1 THEN return1 once value2 THEN return2 … ELSE default come back finish
\nThe CASE statement\u00a0is employed to perform a logical check and come back values supported the result. CASE operates are often rewritten as AN IF function, however, the CASE Logical functions are usually times less complicated to jot down and shorter.<\/p>\n

Here\u2019s AN example of a formula:<\/p>\n

\"Tableau<\/a>

Tableau CASE Statement – Logical Functions<\/p><\/div>\n

This CASE statement creates a replacement field by exploring the country field. Once the worth \u201cUnited States\u201d is found, it uses \u201cUSA.\u201d once \u201cUnited Kingdom\u201d is found, it uses \u201cUK.\u201d All alternative values receive the worth \u201cWorld.\u201d
\nLet’s revise Adding Worksheets And Renaming Worksheet In Tableau<\/strong><\/a><\/p>\n

b. IF Statement<\/h4>\n

IF check THEN worth finish \/ IF check THEN worth ELSE else finish<\/p>\n

Tableau IF statement creates a logical check. IF check is true THEN do y. The check a part of the operations should be a mathematician, either by employing a mathematician field within the knowledge supply or because of the results of AN expression victimization operators or logical comparisons (AND, OR, NOT).<\/p>\n

Here\u2019s AN example:<\/p>\n

\"Tableau<\/a>

Tableau IF Statement – Logical Functions<\/p><\/div>\n

IF test1 THEN value1 ELSEIF test2 THEN value2 ELSE else finish<\/p>\n

You can expand the practicality of the IF logical functions with the ELSEIF by adding extra IF-THEN statements. for instance, here we will recreate our CASE formula on top of victimization AN IF-THEN-ELSEIF statement:<\/p>\n

\"Tableau<\/a>

Tableau IF Statement – Logical Statement<\/p><\/div>\n

Same result as our CASE operate, grouping all alternative values into World and abbreviated the USA and United Kingdom of Great Britain and Northern Ireland.<\/p>\n

c. IFNULL Statement<\/h4>\n

IFNULL(expression1, expression2)<\/p>\n

The IFNULL statement primarily runs a true\/false check on whether or not the worth within the tested field is NULL. The primary worth within the operate is employed if the worth isn’t null, and also the second is employed if it’s null.<\/p>\n

\"Tableau<\/a>

Tableau IFNULL Statement – Logical\u00a0Functions<\/p><\/div>\n

If any country\u2019s Total Population doesn’t have a price, then it’ll be reset as zero and removing the null from the fresh created field.<\/p>\n

Let’s watch Tableau Data Extract \u2013 How to do Data Extraction in Tableau<\/strong><\/a><\/p>\n

d. IIF\u00a0Statment<\/h4>\n

IIF(test, then, else, [unknown])<\/p>\n

The IIF statement is just like the IF operate on top of. It primarily creates a shorthand operate for AN IF-THEN-ELSE statement with the additional advantage of being to outline a price with the ultimate argument if the check yields AN unknown result. Remember, a bit like the IF operate, the check should be mathematician by knowledge kind or lead to a mathematician worth as a results of the check.<\/p>\n

Let\u2019s take a glance at AN example:<\/p>\n

\"Tableau<\/a>

Tableau IFF Statement – Logical Functions<\/p><\/div>\n

If the sphere take advantage of modification is a smaller amount than five-hitter then my formula on top of can come back a price of Poor, otherwise it’ll come back sensible.<\/p>\n

e. ISDATE\u00a0Statement<\/h4>\n

ISDATE(string)<\/p>\n

The ISDATE statement tests whether or not the string argument are often born-again to a legitimate date (TRUE) or if it cannot (FALSE). Here\u2019s AN example:<\/p>\n

\"ISDATE<\/a>

ISDATE Statement – Logical Functions<\/p><\/div>\n

The on top of a formula is approved by Tableau as a result of the sphere that we have a tendency to used is so a string knowledge kind, however, each result can clearly be FALSE. you would possibly use this logical functions. If your date is formatted in an exceeding vogue you would possibly not acknowledge, like ISO 8601. Here\u2019s AN example:<\/p>\n

\"ISDATE<\/a>

ISDATE Logical Functions<\/p><\/div>\n

The on top of worth represents Sept one, 2014 and so may be a valid worth for a date.
\nLearn Tableau Save, Reorder and Delete Worksheet<\/strong><\/a><\/p>\n

f. ISNULL\u00a0Statement<\/h4>\n

ISNULL(expression)<\/p>\n

Another straightforward statement, ISNULL, merely tests whether or not AN expression is null (TRUE) or not (FALSE).<\/p>\n

\"ISNULL<\/a>

ISNULL Statement – Logical Functions<\/p><\/div>\n

If you wish to filter null values from your image, you’ll be able to filter null values with the Filter card.<\/p>\n

g. ZN Statement<\/h4>\n

ZN(expression)<\/p>\n

The last logical Functions are that the atomic number 30 operate. It\u2019s a variation on the ISNULL and IFNULL operate. Atomic number 30 tests to ascertain if a operate is null, and if it’s, it’ll come back a price of zero.<\/p>\n

\"ZN<\/a>

ZN Statement – Logical Functions<\/p><\/div>\n

The first time you see a listing of logical functions, there\u2019s the inevitable hesitation on what all of this suggests. Currently that we\u2019ve suffered all, hopefully, you\u2019ll notice them helpful in investing your knowledge and your image even over before. If you wish to leap in and learn a lot of regarding once to use these functions, here’s a good post.
\nLet’s Discuss Tableau\u00a0Highlight Table – Steps to Build Highlight Table<\/strong><\/a><\/p>\n

Conclusion<\/h3>\n

In this tutorial, we studied the different logical functions: CASE Statement, IF Statement, IFNULL Statement, IIF Statement, ISDATE Statement, ISNULL Statement, ZN Statement in a tableau with examples, and how we can use Logical statements in tableau to perform various operations.<\/p>\n

Share your feedback or queries in the comment section.<\/p>\n","protected":false},"excerpt":{"rendered":"

In this tableau tutorial, we are going to study about Tableau Logical functions and different logic statements with examples that we can perform in Tableau. So, let us start tableau Logical Functions. Tableau Logical...<\/p>\n","protected":false},"author":5,"featured_media":10317,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[71],"tags":[2313,6452,6460,6461,7318,7325,8379,8381,14343,14344,16354],"class_list":["post-10307","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tableau","tag-case-statement","tag-if-statement","tag-ifnull-statement","tag-iif-statment","tag-isdate-statement","tag-isnull-statement","tag-logic-statements-in-tableau","tag-logical-functions-in-tableau","tag-tableau-logic-statements","tag-tableau-logical-functions","tag-zn-statement"],"yoast_head":"\nLogical Functions | Logic Statements in Tableau - DataFlair<\/title>\n<meta name=\"description\" content=\"Logical Functions in Tableau,CASE Statement,IF Statement, IFNULL Statement,IIF Statment,ISDATE Statement,ISNULL & ZN Statement with examples\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/tableau-logical-functions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Logical Functions | Logic Statements in Tableau - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Logical Functions in Tableau,CASE Statement,IF Statement, IFNULL Statement,IIF Statment,ISDATE Statement,ISNULL & ZN Statement with examples\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/tableau-logical-functions\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-03-08T12:52:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-01T10:32:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Logical-Functionsl-in-tableau-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Logical Functions | Logic Statements in Tableau - DataFlair","description":"Logical Functions in Tableau,CASE Statement,IF Statement, IFNULL Statement,IIF Statment,ISDATE Statement,ISNULL & ZN Statement with examples","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/tableau-logical-functions\/","og_locale":"en_US","og_type":"article","og_title":"Logical Functions | Logic Statements in Tableau - DataFlair","og_description":"Logical Functions in Tableau,CASE Statement,IF Statement, IFNULL Statement,IIF Statment,ISDATE Statement,ISNULL & ZN Statement with examples","og_url":"https:\/\/data-flair.training\/blogs\/tableau-logical-functions\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-03-08T12:52:07+00:00","article_modified_time":"2025-03-01T10:32:45+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Logical-Functionsl-in-tableau-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/tableau-logical-functions\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-logical-functions\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823"},"headline":"Logical Functions | Logic Statements in Tableau","datePublished":"2018-03-08T12:52:07+00:00","dateModified":"2025-03-01T10:32:45+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-logical-functions\/"},"wordCount":1001,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-logical-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Logical-Functionsl-in-tableau-01.jpg","keywords":["CASE Statement","IF Statement","IFNULL Statement","IIF Statment","ISDATE Statement","ISNULL Statement","Logic Statements in Tableau","Logical Functions in tableau","tableau Logic Statements","Tableau Logical Functions","ZN Statement"],"articleSection":["Tableau Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/tableau-logical-functions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/tableau-logical-functions\/","url":"https:\/\/data-flair.training\/blogs\/tableau-logical-functions\/","name":"Logical Functions | Logic Statements in Tableau - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-logical-functions\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-logical-functions\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Logical-Functionsl-in-tableau-01.jpg","datePublished":"2018-03-08T12:52:07+00:00","dateModified":"2025-03-01T10:32:45+00:00","description":"Logical Functions in Tableau,CASE Statement,IF Statement, IFNULL Statement,IIF Statment,ISDATE Statement,ISNULL & ZN Statement with examples","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/tableau-logical-functions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/tableau-logical-functions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/tableau-logical-functions\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Logical-Functionsl-in-tableau-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/03\/Logical-Functionsl-in-tableau-01.jpg","width":1200,"height":628,"caption":"Tableau Logical Functions | Logical statements"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/tableau-logical-functions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Tableau Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/tableau\/"},{"@type":"ListItem","position":3,"name":"Logical Functions | Logic Statements in Tableau"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/7f83c342f5d1632d6f7b4b0b0f447823","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4cf3a74600d131330b8c481d519afd1574093ed89f6d3396a95393ad223eb7cd?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team creates expert-level guides on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our goal is to empower learners with easy-to-understand content. Explore our resources for career growth and practical learning.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam1\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/10307","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=10307"}],"version-history":[{"count":5,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/10307\/revisions"}],"predecessor-version":[{"id":144376,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/10307\/revisions\/144376"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/10317"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=10307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=10307"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=10307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}