what is the difference between if and iif in tableau?
The IIF statement distinguishes TRUE, FALSE and UNKNOWN; whereas an IF statement only worries about TRUE and not true (which includes both FALSE and UNKNOWN). Use the IF THEN ELSE function to perform logic tests and return appropriate values.