How to use a IFF statement in Tableau

0 votes
I am trying to use IFF statement. So, if the condition passes, it will not alter anything but if it fails, i want it to display "null value".
Apr 5, 2018 in Tableau by GandalfDwhite
 • 1,320 points • 1,920 views

1 answer to this question.

0 votes

Use this syntax - 

IIF(([Avg_sale] > [Today]),STR([Avg_sale),"Null value")
answered Apr 5, 2018 by QueenBee
 • 1,820 points

Related Questions In Tableau

0 votes
1 answer

How can I use Tableau to create a heatmap?

Step 1: Create an Excel Spreadsheet with ...READ MORE

answered Apr 2, 2018 in Tableau by ffdfd
 • 5,550 points • 2,911 views
0 votes
1 answer

How to group bins in a tableau histogram?

One of the simple way is by ...READ MORE

answered Apr 3, 2018 in Tableau by xyz
 • 1,560 points • 6,861 views
0 votes
1 answer

How to calculate the percent of records within a group in tableau?

 You can click the measure SUM(Number of Records) and ...READ MORE

answered May 9, 2018 in Tableau by ffdfd
 • 5,550 points • 4,804 views
0 votes
6 answers

How to use COUNTIF in Tableau?

I'll give you a brief idea on ...READ MORE

answered Dec 10, 2018 in Tableau by Haider
 • 36,326 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
 • 10,240 points • 9,901 views
+2 votes
1 answer

How to Link Dashboard with URL to enable it to open in the same explorer page

Add this to the end of the ...READ MORE

answered Mar 27, 2018 in Tableau by ffdfd
 • 5,550 points • 3,521 views
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
 • 10,240 points • 1,599 views
+2 votes
1 answer

How can I download tableau workbook with its data from tableau server?

In essence, no. Since the workbook is ...READ MORE

answered Mar 27, 2018 in Tableau by ffdfd
 • 5,550 points • 9,891 views
0 votes
1 answer

How should I prepare in order to get Tableau certified?

There are tonnes of video tutorials and ...READ MORE

answered May 10, 2018 in Tableau by QueenBee
 • 1,820 points
edited Sep 21, 2021 by Soumya • 659 views
0 votes
1 answer

Dropdown to change x-axis in Tableau

You need to create a  str datatype parameter ...READ MORE

answered Apr 4, 2018 in Tableau by QueenBee
 • 1,820 points • 1,295 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.