How to make a Treemap function like a Filter Pane?

[ogatchell]

Is there an expression that can make a Treemap work like a filter pane?

In this case, the field is Manufacturers. Similar to a filter pane, the Treemap will display all the field values; and when one or more Treemap field values are selected, those values will turn green, and all unselected values will turn grey. However, unlike a filter pane, values that could have been selected, viz., light grey values will also turn grey. And when the value of a field associated with Manufacturers, for example a City value, is selected and that value is associated with one or more Manufacturers, those values will turn green and unassociated values will turn grey.

This is important: in the Treemap, field values will appear in equally-scaled boxes; in other words, measures do not count, literally.

The purpose of this Treemap is to impress upon the user positive and negative space within dimensions and to help the user first see existential patterns immediately (whether something exists) vs patterns based on measures. I have noticed in a Treemap I have created where the Dimension is Manufacturers and the measure is sum ({1}Sales), many values do not appear or are so small, they are barely noticeable. Btw, the expression code to color Treemap selections/unselections is "if (Sum(Sale) > 0, Green(), DarkGray())" and assume I will continue using this in a "filter pane" Treemap.

If you have any better ideas about how to accomplish the same goal, please suggest; for example, a better chart, something that already exists, or a filter pane extension that accomplishes the same; in all cases, the chart must be able to operate in Qlik Cloud.

[Michael_Tarallo]

Hi there Ogatchell - I have read your requirements and am forwarding this to a few colleagues that might have some options. Please note that our customer and partner event QlikWorld is this week and their reply may be delayed. I will forward them this thread. If you don't hear anything, please let me know.

@Patrik_Lundblad  @Patric_Nordstrom  - if you guys have any ideas that would be awesome.

[Patric_Nordstrom]

@ogatchell @Michael_Tarallo 

If the boxes should have equal size, then use a measure that would be the same for Manufacturers, for instance avg({1} 1). 

[ogatchell]

thanks, Patric - I don't quite get the same result, but this is not a showstopper (see attachment). I can live with this. However, I would like to revisit the question, do you have any additional suggestions for a better chart. While the Treemap is sufficient, is there, in your mind, a brushed chart (ie image), that better highlights selected and unselected values?  Playing with the idea, you can also see how a pie chart works as well (2nd attachment)To paraphrase a well-known saying, a picture is better than "a list box or filter pane".