Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Equivalent of Spotfire Filter Panel

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.
Tags (2)
1 Reply
Not applicable

Re: Equivalent of Spotfire Filter Panel

I was not familiar with Multibox; that is a built-in one-step solution.

Some documentation

It is good ; it solves the main problem of "preventing multiple ListView filters from taking up too much screenspace" but I think Multibox falls short on these counts:

  • Can't search/filter which Fields are shown; must define it in Properties
    • See below, can apply a clever use of Subfield function to show rows only for those $Fields which the user has selected.
    • Can connect this with a Search which is pointed at the List of Fields , $Field, and which uses Wildcard search. See attached.
    • But this is not a single "dynamic" multibox, this is just a bunch of multiboxes (one for each filter; must be manually created by the developer); the Subfield and GetSelectedCount functions must be passed an index, "n" for each one
    • Each Multibox passes an incremented integer index to the Subfield function (third optional parameter) to decide which $Field to show
    • In addition, there is conditional visibility, requiring that the GetSelectedCount of $Field is >=n
    • This brings up important nuance; if the user hasn't selected any $Field at all, should this "Filter panel" be completely empty or completely full? I think completely full is less confusing.
    • Therefore I modified Multibox.qvw from the post below to 1) add a Search and 2) show all $Fields if none is selected
  • Can't search/filter which values (for a specific Field); it just shows a ListView pop
  • Can't choose something other than a ListView  popup; i.e. can't show slider for numeric-type values, or text-search (i.e. autocomplete) for text-type values
  • Can't group Fields (apparently Spotfire Filter Panels can "group" under directories)

I'll check out this post

Show/hide a field in multibox

Community Browser