The IF, THEN, ELSE, ELSEIF, IFNULL, IIF, AND & OR functions in Tableau

[@divemaster5000]

This is the best Tableau training I have found! My own professor doesn't explain it this simply and straightforward

[@mmuluget]

The best Tableau content I have ever come across on KZbin. You explained the formulas and the logics behind them in a manner anyone can understand. Thank you!

[@mensamapees4686]

I can't stop watching your tableau videos. Thanks a lot keep up with the good work.

[@edwarda.2069]

Thank you so much, Tim, for the simplification and understanding you bring to your tableau tutorials.

[@TableauTim]

Glad you like them!

[@fifafriedman]

@@TableauTim Hero

[@BZero]

Awesome job! You really clear the air with all these tips. Thanks a lot and greeting from Brazil.

[@TamerAgha.]

Wonderful content! Very clear explanation! Keep up the good work mate.

[@smellypunks]

Nice 1440p and 4K quality video. many thanks

[@smarty24uk]

Great Work Tim. Really liked it!

[@stevemond1]

This video just saved my life, Mucho grazia amico

[@tiendang9371]

Tks for uploading your video, which is useful and helpful for my job career

[@oluyomifadipe5634]

Great content bro. Very well explained. But as you said it would make more sense to do all the work in a data prep tool. i would do this in SQL before transferring my data over.

[@melfleming6675]

Thank you! This was great! Had to subscribe. Keep the videos coming!!!

[@kondrusharathchandra]

Content Quality is mind-blowing and the way you explain the details are amazing!! Thanks a lot for the content. Do you have any structured courses online?

[@TableauTim]

I have a LinkedIn learning course. If you follow my profile there’s a link to access it free for 24hours but beyond that not yet. All my time and effort goes into the 490 plus videos on the channel. That’s more than any course anywhere so I’d recommend you check out my playlists as those are structure like courses. I also have a tableau crash course on KZbin that’s 4 hours long just browse my channel page playlist and videos.

[@vdn5716]

As usual best video Tim...Please make some videos on server side also ..very less content on server admin part , it will ne helpful to us..Thanks

[@TableauTim]

Sure that's quite a big ask so I've setup a roadmap system where you can maybe add some suggestions on topics you'd like to see. If you can post them there thats much easier for everyone to track. shrtm.nu/XC6B

[@vdn5716]

@@TableauTim thanks

[@WestCoastKop]

solid and simple explanationsl

[@hpujari]

Nice one 😄

[@nolondajones2255]

Thank you so much for this! Your videos are awesome!

[@TableauTim]

Pleasure

[@msamir405]

Thank you very much. I have one question which is. I want to use "If" function in Tableau but I want to choose part of the discription( not the whole) to set a new category. Appreciate your help.

[@tableaututorialstips71]

fantastic we are expecting lenghty vieos :) thanks lot :)

[@siriansight]

excellent video

[@praveenkumarchidrawar9008]

Thankyou.

[@TableauTim]

You're welcome

[@RameshCh-me8jm]

Beautiful explanation 🙂

[@TableauTim]

Glad you liked it

[@AliciaMarkoe]

iif stands for "if and only if" 🦋

[@rajashekarn2000]

Good work, keep it going.. Tim

[@eugeniab9680]

I really liked it! The content and the way you explain. Thanks for doing this! :-)

[@Maxine339]

Thanks!

[@TableauTim]

No problem! and thank you for your generosity!

[@venkatc1323]

👌👌👌👌👌👌👌👌,grt keep going on, pls take use cases also

[@Peace3132_]

Hello Tableau Tim, your content has been very useful and I was wondering of you can help me fix a calculation error? The error says expected then to match case at character 14. Thank you for being so helpful CALCULATION SUM([weight]) * (CASE [NumeratorFlag] WHEN [NumeratorFlag])’1’ THEN ‘1’ ELSE ‘0’ END

[@teex2011]

Do you provide online lessons for specific areas or 1 on 1?

[@nivedhithas811]

Hey Tim, would you mind checking the link for mock data, i am not able to access it seems to be deleted. Thanks Tim !

[@TableauTim]

Fixed shorturl.at/VUgzJ

[@saurabhbhatnagar4243]

Superb !!

[@eilenkatarinalunde2969]

Hi Tim! Thanks so much for your videos! I have a question regarding nulls: When I'm using the NULL statement on the Superstore dataset, it returns text saying "Null" instead of actually removing the values. Would you happen to know why? I appreciate your help!

[@eilenkatarinalunde2969]

I figured it out - it's because I put the calculation as discreet and not continuous in the text table!

[@edwarda.2069]

Hi Tim, Do you have a video for date function calculations in your playlist? Thank You

[@TableauTim]

Not yet I skipped that one but it’s still on the to do list

[@AhmerJamil]

Ver Well done!! IIF called as Immediate IF

[@TableauTim]

Not sure everyone on Twitter agrees twitter.com/tableautim/status/1359585430610599941?s=21 aha

[@jhancrepsac9256]

Hi @Tableau Tim I'm currently in a data analytics course at my university and I'm having trouble with creating a calculated field that uses a logical statement to change the Borough field from numbers to the name of the Borough. In short how do you create a logical formula to translate from one data type to another I.E (if number = X then name should change to Y) Please advise if you can, would be greatly appreciated.

[@TableauTim]

It’s really hard to use these comments for this. Could you create a suggestion here if you’d like a little more support? Add screenshots and we can maybe figure out a video that will help everyone. tableautim.canny.io/suggestions

[@Sbudarh_P]

Hi @TableauTim is it possible to display the age range in tableau, let's say Iike display only data for ages between 24-30 using the IF Statement?

[@TableauTim]

Yes you could do this just by writing an if statement that groups the data. If age is greater than 0 and less then or equal to 5 then age 0-5 else-if age is greater than 5 but less than equal to 10 then age 6-10 etc etc. The other way is to turn ages into whole numbers and create groupings using group function or lastly use the bin function.

[@Sbudarh_P]

@@TableauTim thanks for the quick response I will give another try, by the way am new to Tableau thanks to your videos now I can create great dashboards. I hope in the near future you will make a video about this case.

[@games0009]

for example If [DATA] > 10, then "Max" else [DATA] end. I tried this, but shows error, can you please suggest..(I want data which is greater than 10 to print as Max, if not to show those values less than 10.

[@TableauTim]

youre mixing data types. text and numbers cant come from the same calculation. Make your values into text by doing this. if [DATA] > 10, then "Max" else STR([DATA]) end the STR function makes a value into text. But bear in mind you then cant aggregate these.

[@NehaKumari-hg4cc]

I am getting error:- Expected 'End' to match 'IF' at character 0 What will be the solution to make it correct?

[@TableauTim]

You need to check your calculation. Your missng and end clause somewhere or you have one too many IFs... common error on Google as well with lots of tips. www.google.com/search?q=Expected+%27End%27+to+match+%27IF%27+at+character+0+tableau&oq=Expected+%27End%27+to+match+%27IF%27+at+character+0+tableau&aqs=chrome..69i57j0i22i30j0i390l2.3029j0j7&sourceid=chrome&ie=UTF-8

[@459selenio8]

hello, how to do to get the best workers in performance, I hope your help

[@TableauTim]

sorry could you explain your idea in more detail here shrtm.nu/XC6B thanks.

[@finewine8886]

Do you provide private lessons or mentoring?

[@blackwhite2361]

The Videos on this channel is enough Mentoring if you ask me

[@HarryInAction10]

Sexy Music at the Back ! Vibing really good XD