Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor

Hierarchy structure in Filter pane

Hi,

I am trying to show a hierarchy between two fields in a filter pane. The below is a table with the dimensions.

StateBranchOrder
PAPittsburgh1
PAErie2
PAPhiladelphia3
OHCleveland1
OHAkron2
OHCincinnati3


The below is how i want to show in the Filter pane.

PA

   Pittsburgh

   Erie

   Philadelphia

OH

    Cleveland

    Akron

    Cincinnati

Please suggest how it can be achieved in Qlik sense.

 

Thanks in advance.

3 Replies
Highlighted
Partner
Partner

Re: Hierarchy structure in Filter pane

As far as I know this isn't possible. 

Best alternative I can think of is using two separate filters, so one with the states and one with the branches.

If you really want it, you could try making a table/data like this:

ValueValuePos
PA1
        Pittsburgh 2
        Erie3
        Philadelphia4
OH5
        Cleveland6
        Akron7
        Cincinnati8

 

And then sort based on the ValuePos. 

I would advise against it though, because this isn't really the way you should use filters.

Highlighted
New Contributor

Re: Hierarchy structure in Filter pane

Thanks for the quick response, i have just given two fields in the hierarchy as an example but i have more than 4 levels and from the alternative way i would see more filter panes on the sheet.

coming to the creating the table like below, i would have to duplicate the data or have circular joins in the data model?

ValueValuePos
PA1
        Pittsburgh 2
        Erie3
        Philadelphia4
OH5
        Cleveland6
        Akron7
        Cincinnati8
Highlighted
Partner
Partner

Re: Hierarchy structure in Filter pane

Yeah, you probably have to duplicate the data. I would create a new table inside the data model for this filter alternative. Some things you need to think about:
- You need a good key with your normal data.
- You need to base the ValuePos on the "Value" column. You can probably do this with some loops/if statements.

Another alternative, is to just throw in all the fields in 1 filter box and make it really small, so it becomes like a button that expands on click.