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 in Tableau by Nithin
39 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 by Cherukuri
• 31,840 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 in Tableau by ch
• 3,290 points
27 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
184 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 8, 2018 in Tableau by Atul
• 5,530 points
281 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 20, 2018 in Tableau by Atul
• 10,240 points
47 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
2,256 views
+1 vote
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
104 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 in Tableau by Cherukuri
• 31,840 points
71 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 in Tableau by Cherukuri
• 31,840 points
415 views