I've never used Spotfire, but the client wants something like the "Filter Panel", seen in these screenshots:
Here is some Spotfire Documentation Spotfire Filters ⊂ Spotfire Technology Network. I don't think it's relevant.
And here are requirements that we are inferring from the Spotfire screenshots (PS
- Can Search in a Search Box to filter $Fields
- I don't mean you can Search to filter values, i.e. rows. QlikView is great at that.
- I mean you can Search to filter $Fields; i.e. columns
- Can choose which of the $Fields can be discovered here
- A container object holds a separate component for each $Field the user picks from above
- The component for each $Field is usually a standard List View, but it could be a slider, could be a customized List View
- The component/$Field itself is searchable, to filter the values, and select among them. QlikView can do this easily, as stated above.
- If the $Field is not selected, its component is not just invisible, it is collapsed
- In CSS / HTML terms, I mean it's not just visibility:hidden, it is display:none.
- In QlikView terms, I mean it's not just conditionally hidden, it will be removed from a "flow" of components, so the components beneath it will jump up to take its place.
I won't belabor more details. You probably know what I'm talking about. Have you made something like it?
I made three variations in QlikView.
- The first uses Container object plus Search box against the $Fields dimension.
- The second and third use a CrossTable to make a lookup based on all combinations of $Field+FieldValue (I know this seems like a hacky solution; the lookup will mean that QlikView associations (Green, white, grey) don't work as expected)
- The second shows this in a Pivot table; the third shows this in a Hierarchical List View.