Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.