-
1. Re: QT: Dynamically Switch Images Using Filter
Tracy RodgersJul 19, 2012 12:21 PM (in response to Shawn Wallwork)
Shawn! This is great!! Thanks so much for sharing--I never knew about this trick!
-
2. Re: QT: Dynamically Switch Images Using Filter
Shawn Wallwork Jul 20, 2012 8:52 AM (in response to Tracy Rodgers)Glad you liked it Tracy.
--Shawn
-
3. Re: QT: Dynamically Switch Images Using Filter
Oscar Jara Nov 19, 2013 7:42 AM (in response to Shawn Wallwork)thank Shawn... nice trick
-
4. Re: QT: Dynamically Switch Images Using Filter
Shawn Wallwork Nov 19, 2013 7:55 AM (in response to Oscar Jara)Oscar, glad it worked for you. Happy you found it a year later.
--Shawn
-
5. Re: QT: Dynamically Switch Images Using Filter
Bhujang Hundre Nov 25, 2013 10:26 PM (in response to Shawn Wallwork)
Shawn nice trick and thanks for sharing i didn't knew this option exist to define filter selection---Bhujang
-
6. Re: QT: Dynamically Switch Images Using Filter
Amandine Ricaud Dec 6, 2013 6:32 AM (in response to Shawn Wallwork)Thanks a lot Shawn, it's a really nice trick and exactly what I was looking for.
Just one question though... When "(All)" is selected on the quick filter, the image of one of the products is displayed, while this is not the case for products not having any image assigned.
Any idea how to solve this?
Thanks,
Amandine
-
7. Re: QT: Dynamically Switch Images Using Filter
Shawn Wallwork Dec 6, 2013 7:02 AM (in response to Amandine Ricaud)Amandine, glad you found it useful. Generally I don't turn on the ALL option (Customize uncheck 'Show "All" Values'). I also set the filter to use 'Only Relevant Values'. And then assign an image to the various values.
What exactly are you trying to do? Not have to assign images to all products?
--Shawn
-
8. Re: QT: Dynamically Switch Images Using Filter
Amandine Ricaud Dec 6, 2013 8:51 AM (in response to Shawn Wallwork)Thanks for your quick reply, Shawn.
Unfortunately I need the ALL option to be available.
On my dashboard, my list of products contains individual products (camomille, mocca, etc...) but also products which are grouped together, for example something like "sold out beverages" for which I do not have a picture since it is several products altogether. But this actually works without any problem. When I select one of these products, no picture shows up and it is fine.
The only problem is that I need to be able to show as well all products together on this dashboard. And when I do so by using the ALL option, it displays the picture of one of the individual products, while I would like to have no picture instead.
And I do not really understand why this is the case or how the picture is selected.
Do you think that there is another trick to get around this issue? :-)
Thank you in advance and have a nice weekend,
Amandine
-
9. Re: QT: Dynamically Switch Images Using Filter
Shawn Wallwork Dec 6, 2013 10:18 AM (in response to Amandine Ricaud)Unfortunately Tableau doesn't give us a hook into the '(All)' that it generates so there is no way (that I know of) to write a calculation that uses All. As to how does T select a picture to show when all is selected, it probably goes to the first one in the list or alphabetically (or possibly the last one ).
Without a sample workbook it is difficult to tell you what to do. But I sounds like you might be able to use some combination of Dashboard Actions and calculations to reach your goal. Post a twbx and I can help you work it out.
--Shawn
-
10. Re: Re: QT: Dynamically Switch Images Using Filter
Joshua Milligan Dec 6, 2013 10:47 AM (in response to Amandine Ricaud)Amandine,
One thing you might try is creating a calculated filed with Size() as the calculation. Place that on Filters and select "At Most 1". Make sure it is computed along Product. That way, when you have a single product selected, the Size is 1 and the image is shown. When you select "All" the Size() is more than 1 and nothing is shown.
Regards,
Joshua
-
Image Switches.twbx 996.4 KB
-
-
11. Re: QT: Dynamically Switch Images Using Filter
Jonathan DrummeyDec 6, 2013 12:10 PM (in response to Joshua Milligan)
Nice one, Josh!
Shawn, here's a way to find out when All is selected: Identifying (and Using) Quick Filter Selection Status | Drawing with Numbers. The basic process is to use a self-blend that is not filtered, so you always have a source of truth to know how big "All" is, then you use a calculated field to test for that.
-
12. Re: QT: Dynamically Switch Images Using Filter
Amandine Ricaud Dec 12, 2013 4:12 AM (in response to Shawn Wallwork)Dear all,
thank you very much for your help. It works exactly as intended now, using your different suggestions and tricks.
Many thanks :-)
Amandine
-
13. Re: Re: QT: Dynamically Switch Images Using Filter
Ville Tyrväinen Dec 12, 2013 5:17 AM (in response to Shawn Wallwork)Hi Shawn,
I used the same method as you to put Powerpoint slides into Tableau to get a slideshow :-)
Ville
-
PP_1.twbx 251.9 KB
-
-
14. Re: QT: Dynamically Switch Images Using Filter
Christian Sonnberger Jan 8, 2014 6:40 AM (in response to Shawn Wallwork)Shawn,
this is great! Works perfectly if I use it offline. As I'm using tableau public 8.1 I want to use this trick especially online. In this case no pictures are displayed at all. Any idea what the problem could be? Any settings that must be considered?
I used a filter-action an the dashboard instead of a quick-filter:
Workbook: WIP_StadtteileThanks,
Chris
... solved the problem. You shouldn't use German 'Umlaute' (like ä, ö,ü or such) in the file-path.