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
41 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
• 32,260 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
31 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
195 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
332 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
53 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,419 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
118 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
• 32,260 points
90 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
• 32,260 points
475 views