QlikView: Emulate File Explorer (HierarchyBelongsTo?)

tdegen_qlik — Thu, 02 Feb 2023 15:05:27 GMT

We have files on a server (research documents, but for the sake of an easy example - let's suppose they are .gif files).

I want our users to be able to use QlikView to navigate through a folder structure to find the files they need and be able to download them. I already have a utility that is fully functional (searching, sorting, download, etc.) what I want to add is the folder structure in a filter using tree view.

If my Data Set looks like:

FileID (hash)	FilePath	FileName
asdf34hsdf%87^%tyh	/Root/grandparent/parentfolder01/path01/	myFileName01.gif
asdfkjh3876%56twe	/Root/grandparent/parentfolder02/path02/	myFileName02.gif
ashsdfhjjh^^%67	/Root/grandparent/parentfolder02/path02/	myFileName03.gif
sdfjlkjlk^&76uujkgh	/Root/grandparent/parentfolder01/	myFileName_01.gif
jlkasdfjksdf78%$%^Fh	/Root/grandparent/	my__File__Name__01.gif

How do I get this into a treeview in such a way that when I click on "ParentFolder01" I see everything at or below that folder level? I think this is a "HierarchyBelongsTo" exercise, but I'm not sure how to configure my data set.

topic QlikView: Emulate File Explorer (HierarchyBelongsTo?) in App Development

QlikView: Emulate File Explorer (HierarchyBelongsTo?)