topic Hierarchical filter panel in Integration, Extension & APIs

Hierarchical filter panel

JulienCms — Mon, 03 May 2021 15:55:56 GMT

Hello,

I try to create a hierarchical filterpanel as we find in excel when filtering on a date field (see screen).

For that I started from this extension : Hierarchy tree filterpane

The problem is when I make a selection (API Field so there is'nt a repaint, it's good) but when a repaint occurs (resize or if I switch in an another sheet and I come back for example), the visualization is redrawn but only with the selected values.

There is a solution to keep the selection and that the repaint is done with all values regardless of the selection?

Thank you in advance.

Re: Hierarchical filter panel

JuanGerardo — Mon, 03 May 2021 17:59:25 GMT

Hi @JulienCms , have you checked the Date Picker included in the Qlik Dashboard Bundle?

https://help.qlik.com/en-US/sense/February2021/Subsystems/Hub/Content/Sense_Hub/Visualizations/DashboardBundle/date-range-picker.htm

Re: Hierarchical filter panel

JulienCms — Mon, 03 May 2021 19:13:45 GMT

Hi @JuanGerardo , thank you for your answer!

The idea is to work with hierarchical data, not dates, I used dates to illustrate the graphical rendering in excel.

What is interesting with this extension is that when we select a parent node all the child nodes are also selected.

It looks like this :

Originally when a selection is made with this extension it overwrites the one before. I managed to allow multiple selections. Now my problem is when there is a repaint. It repaints only with the selected values.

I'm looking for a track, maybe use another object than the hypercube. I saw in the documentation that there is an object named TreeData but I couldn't find a tutorial on how to use it.

Thank you.

Re: Hierarchical filter panel

JuanGerardo — Mon, 03 May 2021 19:23:07 GMT

OK, I see. I think this hierarchical data comes from the QlikView times, to feed the listbox tree view, for example like here: https://community.qlik.com/t5/QlikView-App-Dev/Create-a-Tree-view-Listbox/m-p/1196676

Re: Hierarchical filter panel

JulienCms — Mon, 03 May 2021 19:39:48 GMT

Yes exactly. Is there a way today to display a hierarchical listbox with QlikSense? On all posts it seems not.

Re: Hierarchical filter panel

JuanGerardo — Mon, 03 May 2021 21:13:20 GMT

As of today, you are right, it’s not possible as a filter pane. Maybe you find something similar using a pívot table with the expand option. But I think you need to include at least a be measure.
JG

Re: Hierarchical filter panel

JulienCms — Mon, 03 May 2021 21:38:42 GMT

I would have to find a way to manage the selection from this extension, there must be a solution with all the methods proposed in the APIs. Little is missing for this extension to be perfect.