IF vs IIF and performance difference?

Question

I was wondering what is the difference between the IF statement vs the IIF() function in Tableau. And then I found this page, which explained the syntax difference.

Difference between iif and if

But someone (over a seminar) also told me that IIF() has better performance. Is that true?

Answer 1

IF Function:

IF(Condition, "truevalue", IIF(Condition,"truevalue","falsevalue"))

if it see NULL it will return a False Value

IIF(Condition, "truevalue", IIF(Condition,"truevalue","falsevalue"), "no value")

if it sees NULL it will return no value

Get indepth knowledge about this field through Tableau Certification Course by Intellipaat.

Also, do have a look at our YouTube video to help you get started with tableau training.