QlikView: Emulate File Explorer (HierarchyBelongsTo?)
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.
