You could make your map and then bring Company into tooltip, then bring your rank field in as a filter and filter on 1 only.
Please see the attached workbook.
Mapcompany_v10.2.twbx 7.5 MB
Thank you for your quick response!
Your suggestion works really well. Is it possible to add a second entry in the tooltip for rank two? Filtering over multiple ranks gives me an asterisk - probably because there is more than one value per country (rank 1, rank 2). I guess I can't avoid any calculations?
Oh, and I also tried to concatenate the rows to a single string. Unfortunately string concatenation over several rows isn't an option either. I need the returned string as a stand-alone value.
Just check this link below which helps show multiple values in tooltip without Asterisk (*)
Kindly mark this answer as helpful/correct so that it will help others
Thanks for your help, Naveen!
I tried the solution linked in your post. It works, but unfortunately string concatenation over several rows (a string list of companies) isn't an option. I need the returned string as a stand-alone value.
Thanks again, Mavis!
I should've mentioned, that I'm on Tableau public at the moment and can't open the attached workbook right now.
Finally i was able to open the attached workbook in Tableau. Thank you very much for you effort, Mavis! The value inside the tooltip is a concatenated string. I need the returned string as a standalone value.
The whole thing sounds and looks so simple in pseudo-code, there must be a way to get the country-string as a value. I just need to get the string value from the <company>-column where <Rank> equals 1 or 2 or 3 from a <country> subset (?!).
Is there anyone who can help me with the calculation? As I said, I'm absolutely new to Tableau. Any help would be greatly appreciated.