Skip to main content
Topics#Tableau Desktop & Web AuthoringTableau Community Forums Member (Inactive)'s Question
Tableau Community Forums Member (Inactive) (Salesforce) asked in #Tableau Desktop & Web Authoring
Jun 22, 2018, 1:21 PM

Merge multiple if condition in calculated field

I have 4 column header naming Bucket 1-30, Bucket 31-60, Bucket 61-90, NPA. i want to apply below mention color code all of them. facing syntax error. please suggest.

 

IF [Bucket 1-30]<=0.02 THEN 'Green'

ELSEIF [Bucket 1-30] >0.02 and [Bucket 1-30] <=0.04 THEN 'Amber'

ELSEIF [Bucket 1-30] >0.04 THEN 'Red'

 

ELSEIF [Bucket 31-60] <=0.02 THEN 'Green'

ELSEIF [Bucket 31-60] >0.02 and [Bucket 31-60] <=0.04 THEN 'Amber'

ELSEIF [Bucket 31-60] >0.04 THEN 'Red'

 

ELSEIF [Bucket 61-90] <=0.02 THEN 'Green'

ELSEIF [Bucket 61-90] >0.02 and [Bucket 61-90] <=0.04 THEN 'Amber'

ELSEIF [Bucket 61-90] >0.04 THEN 'Red'

 

ELSEIF [NPA] <=0.02 THEN 'Green'

ELSEIF [NPA] >0.02 and [Bucket 61-90] <=0.04 THEN 'Amber'

ELSEIF [NPA] >0.04 THEN 'Red'

ELSE 'Black' END

17 answers
  1. Mavis Liu
    Jun 26, 2018, 1:30 PM

    Hi Mahendra,

     

    I have pivoted your data:

    Hi Mahendra, I have pivoted your data: Where there will be a new field called pivot field names and pivot field values. You can rename these, for now I've left them as is.

     

    Where there will be a new field called pivot field names and pivot field values. You can rename these, for now I've left them as is.

     

    Then updated the calculation:

    IF [Pivot Field Names] = 'Bucket 1-30' and ([Pivot Field Values])=0.00 THEN 'Black'

    ELSEIF [Pivot Field Names] = 'Bucket 1-30' and ([Pivot Field Values]) <=0.02 THEN 'Green'

    ELSEIF [Pivot Field Names] = 'Bucket 1-30' and ([Pivot Field Values])<=0.04 THEN 'Amber'

    ELSEIF [Pivot Field Names] = 'Bucket 1-30' and ([Pivot Field Values])>0.04 THEN 'Red'

    ELSEIF [Pivot Field Names] = 'Bucket 31-60' and ([Pivot Field Values])=0.00 THEN 'Black'

    ELSEIF [Pivot Field Names] = 'Bucket 31-60' and ([Pivot Field Values]) <=0.02 THEN 'Green'

    ELSEIF [Pivot Field Names] = 'Bucket 31-60' and ([Pivot Field Values])<=0.04 THEN 'Amber'

    ELSEIF [Pivot Field Names] = 'Bucket 31-60' and ([Pivot Field Values]) >0.04 THEN 'Red'

    ELSEIF [Pivot Field Names] = 'Bucket 61-90' and ([Pivot Field Values]) =0.00 THEN 'Black'

    ELSEIF [Pivot Field Names] = 'Bucket 61-90' and ([Pivot Field Values]) <=0.02 THEN 'Green'

    ELSEIF [Pivot Field Names] = 'Bucket 61-90' and ([Pivot Field Values]) <=0.04 THEN 'Amber'

    ELSEIF [Pivot Field Names] = 'Bucket 61-90' and ([Pivot Field Values])>0.04 THEN 'Red'

    ELSEIF [Pivot Field Names] = 'NPA' and ([Pivot Field Values]) =0.00 THEN 'Black'

    ELSEIF [Pivot Field Names] = 'NPA' and ([Pivot Field Values]) <=0.02 THEN 'Green'

    ELSEIF  [Pivot Field Names] = 'NPA' and ([Pivot Field Values]) <=0.04 THEN 'Amber'

    ELSEIF  [Pivot Field Names] = 'NPA' and ([Pivot Field Values]) >0.04 THEN 'Red'

    END

     

    2018-06-26_14h27_59.png

     

    Thanks and please see attached.

    Mavis

Write an answer...
0/9000