Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
JulienCms
Partner - Contributor II
Partner - Contributor II

Hierarchical filter panel

Hello,

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

JulienCms_0-1620057325193.png

 

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.

6 Replies
JuanGerardo
Partner - Specialist
Partner - Specialist

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/Dashb...

JG

JulienCms
Partner - Contributor II
Partner - Contributor II
Author

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 :

JulienCms_4-1620068409094.png

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.

JuanGerardo
Partner - Specialist
Partner - Specialist

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

JG

JulienCms
Partner - Contributor II
Partner - Contributor II
Author

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

JuanGerardo
Partner - Specialist
Partner - Specialist

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

JulienCms
Partner - Contributor II
Partner - Contributor II
Author

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.