5 Replies Latest reply on Aug 24, 2018 3:14 AM by soban ali

    Using Filter as a result of a subquery

    soban ali

      Hi,

       

       

      I have a requirement, I can explain it with a query, how can we use it in Tableau desktop.

       

      select medname from allmedicines where generic in

      (select generic from allmedicines where lower (medname) like '%&Medicine_name%');

       

      I want a filter of "medname" where my requirment is that when I write a "medname" in a filter it gives me all the "mednames" who have the same generic. is it possible in tableau?

       

       

      Regards

      Soban Ali