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,584 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,574 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,502 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,386 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
35,669 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,371 views
+2 votes
1 answer
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,265 views
+2 votes
1 answer
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 432 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
949 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