2 Replies Latest reply on Aug 16, 2017 5:07 AM by shwetha sarma

    Remove duplicates in string list

    shwetha sarma

      Hello, I'm trying to put a string list in tableau tooltip using this source:


      Creating a String List to Display in a Tooltip | Tableau Software


      However, I want to to show sub category in tool tip when I show the product list. (Some of the products are shared by same sub-categories. I want to remove these duplicates)


      *There are no duplicates in the dummy data attached. However, my data is different.


      Formulas used:


      1. { FIXED [State] : SUM([Sales]) }.

      2. '-' + ATTR([City (string)]) + '

      ' + PREVIOUS_VALUE('')

      3. INDEX() <> SIZE()