-
1. Re: IF Statements to Include 1 thing in each IF
Shinichiro MurakamiNov 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
-
2. Re: IF Statements to Include 1 thing in each IF
Deepak RaiNov 24, 2018 7:27 PM (in response to Frederick Page)
-
One Filter 2 Values.twbx 5.7 KB
-
-
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 !