1 Reply Latest reply on Jul 13, 2016 3:28 AM by khalid norat

    Tableau 1 to Many Condition/Filter

    Nader H

      Hey community,


      Been struggling for a while to find a Boolean condition to filter out the following scenario:


      Tableau 1 to many.png


      If Customer Name has registration year = 2014 and 2015 then return rows


      Tableau 1 to many (2).png



      If customer Name has registration year = 2014 but couldn't find a matching record in 2015 then return rows


      Test3   |   2014



      The thing is customer name/ID needs to be taken into consideration as i need to verify if the policy was renewed by the Customer and identify which policies were not renewed. I'll be dealing with 100,000+ rows so hope that gives an idea





      Thanks in advance!