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
59 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
• 32,460 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,380 points
85 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
776 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
883 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
114 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
4,375 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
293 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
• 32,460 points
374 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
• 32,460 points
1,273 views