Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.