Hierarchy structure in Filter pane

[KishoreAdhikari]

Hi,

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

State	Branch	Order
PA	Pittsburgh	1
PA	Erie	2
PA	Philadelphia	3
OH	Cleveland	1
OH	Akron	2
OH	Cincinnati	3

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.

[cpomeren003]

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:

Value	ValuePos
PA	1
Pittsburgh	2
Erie	3
Philadelphia	4
OH	5
Cleveland	6
Akron	7
Cincinnati	8

And then sort based on the ValuePos. 

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

[KishoreAdhikari]

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?

Value	ValuePos
PA	1
Pittsburgh	2
Erie	3
Philadelphia	4
OH	5
Cleveland	6
Akron	7
Cincinnati	8

[cpomeren003]

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.