Show Records where non-null in both fields

0 votes
I want to show Records where non-null in both fields are present. How to do this, The Code i wrote doesn't work and is not giving wrong output?
May 23, 2019 in Tableau by Nithin
417 views

1 answer to this question.

0 votes

Hey,

Try this,  create a calculated field as below to 

IF ISNULL([Field1]) OR ISNULL([Field2]) THEN "One or Both null statements" ELSE " Not NULL statements" END.

The above code would run One or both null statements if even one field value if NULL if both are null then if both are Not Null statements then it would run  

If you use AND then even if both are null then The "One null statements" will be executed and if one is NULL then One is null or not null then Not Null statements will be executed.

Hope it works!

answered May 23, 2019 by Cherukuri
• 33,030 points

Related Questions In Tableau

0 votes
0 answers

Cannot use aggregate and non-aggregate fields in the if statement

Hi. I cannot use aggregate and non-aggregate ...READ MORE

Oct 7, 2019 in Tableau by ch
• 3,450 points
550 views
0 votes
1 answer

how to get the count of non zero values in a row

In first part you should solve the ...READ MORE

answered Apr 4, 2018 in Tableau by Atul
• 10,240 points
2,834 views
0 votes
1 answer

How to calculate the percent of records within a group in tableau?

 You can click the measure SUM(Number of Records) and ...READ MORE

answered May 9, 2018 in Tableau by ffdfd
• 5,550 points
4,406 views
0 votes
1 answer

How to add filter to show latest two dates in tableau?

Steps for filtering based on the most ...READ MORE

answered Jun 21, 2018 in Tableau by Atul
• 10,240 points
1,908 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
9,391 views
+2 votes
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
1,277 views
+2 votes
1 answer
0 votes
1 answer

Show the fields/dimensions in filter used in sheet name in Tableau

Hi Anitha, Follow below steps: 1. Create required visual/chart. 2. ...READ MORE

answered Apr 22, 2019 in Tableau by Cherukuri
• 33,030 points
1,775 views
0 votes
1 answer

Rank measure values and show percentage of measures in Tableau

Hi Sindhu, 1. First create a table with ...READ MORE

answered Mar 8, 2019 in Tableau by Cherukuri
• 33,030 points
3,930 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP