3 Replies Latest reply on Nov 25, 2018 11:22 AM by Frederick Page

IF Statements to Include 1 thing in each IF

Frederick Page Nov 24, 2018 10:19 AM

So I have a dimension that only has 4 outputs. It will either be null, Tier 1, Tier 2, or Tier 3. I want to create one calculated field that will allow me to filter on the data in 3 ways. I want to filter on Tier 1 and include all Tier 1 AND all null entries. I want to filter on Tier 2 and include all Tier 2 AND all null entries. And I want to filter on tier 3 and include all Tier 3 AND all null entries. So basically I want to be able to have the null entries grouped into each of the three Tiers when I filter on them.

Right now my IF statement looks like what is below. However, Tableau only includes the null entries in the Tier 1 portion. When I choose Tier 2 or Tier 3, there are no null entries.

If ISNULL([Mapped Tier Description])=True THEN "Not Crossed"

ELSEIF CONTAINS([Mapped Tier Description], "TIER 1") = True OR ISNULL([Mapped Tier Description])=True THEN "Tier 1"

ELSEIF CONTAINS([Mapped Tier Description], "TIER 2") = True OR ISNULL([Mapped Tier Description])=True THEN "Tier 2"

ELSEIF CONTAINS([Mapped Tier Description], "TIER 3") = True OR ISNULL([Mapped Tier Description])=True THEN "Tier 3"

END

Thanks!!

1. Re: IF Statements to Include 1 thing in each IF

Shinichiro Murakami Nov 24, 2018 12:27 PM (in response to Frederick Page)

If statement handle condition sequentially, so once first condition is met, that value will not go thru next condition.

Then
Create parameter with 4 conditions,

[{Fiter]
if [paramter] = "Closed" then
If ISNULL([Mapped Tier Description])=True THEN "Show" end
elseif [paramter] = "Tier 1" then
IF CONTAINS([Mapped Tier Description], "TIER 1") = True OR ISNULL([Mapped Tier Description])=True THEN "Show" end
elseif [paramter] = "Tier 2" then
IF CONTAINS([Mapped Tier Description], "TIER 2") = True OR ISNULL([Mapped Tier Description])=True THEN "Show" end
elseif [paramter] = "Tier 3" then
IF CONTAINS([Mapped Tier Description], "TIER 3") = True OR ISNULL([Mapped Tier Description])=True THEN "Show" end
END

and filter"Show"

Thanks,
Shin
Like Show 0 Likes(0)

Actions
2. Re: IF Statements to Include 1 thing in each IF

Deepak Rai Nov 24, 2018 7:27 PM (in response to Frederick Page)
Hi Page,
Create One parameter, Create This Calc and Drag it to TRUE.
Thanks
Deepak

One Filter 2 Values.twbx 5.7 KB
Like Show 0 Likes(0)

Actions
3. Re: IF Statements to Include 1 thing in each IF

Frederick Page Nov 25, 2018 11:22 AM (in response to Deepak Rai)

Deepak and Shin, thank you! Both were correct, but I chose Deepak's because his was a bit more elegant and I wanted to eventually end up with a Parameter anyway. Thank you both for your help !
Like Show 0 Likes(0)

Actions