Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hierarchical Data Modelling

There are many situations where we need to model (or Load) Hierachical Data. Some of them :

* Enterprise Depts and their Hierarchy
* Country/State/City
* GrandFather/Fater/Son

And so forth.

I dont know what's the BEST way to load (and represent) this kind of data inside QV. Have done some applications here that manage hierarchic data but I dont know if I've done the best approach.

So, I open up the discussion here.

To pick up a simple, almost universal case, I have chosen a File Directory Tree. As we know there can be as many Folders (directories) and files on any level (depth).

I have provided a sample application, self contained. It loads a CSV file that is a kind of a directory listing, with full path names and file sizes.

When regarded to FILES, it is very easy to build some views, such as Largest files, Oldest ones and so forth.

However, when considering DIRECTORIES (or folders) that is not easy cause original data DOES NOT say the total directory size. We need to calculate it on the application. It would also be nice to COUNT how many files each directory has. It's not very good that a directory (folder) have a very large number of files.

Also we need to break up the file path into several tokens, since we dont know how many levels a file name has. This is variable of course.

How would you implement this problem ? What creative visions do you have to offer ?

0 Replies