Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

jake_qlik
New Contributor

Calculating the size of each subfolders/files and mapping the back to parent folder.

Hi All,

Hope everyone in this community are doing good !

I have recently started learning and coding in Qlikview and am currently stuck up with a problem in my code which is not providing me accurate results.I would be really glad if anyone could depict/correct my mistake in the script and direct me to the right path.

The requirement is when a current parent folder is passed it should show me the sizes of the first 'n' highest disk utilizing folders.Below is a sample illustration:

Parent FolderFirst Level SubfoldersSizeC:\FolderA60
C:\C:\FolderA10
C:\FolderA\FolderB20
C:\FolderA\FolderB\FolderC30

Attached is the script which I have coded to get the results but when the folder levels go deeper, I get wrong results.

Note: I also need to maintain the folder hierarchy.

Attached is the pivot table which I have to generate.Also please let me know how to remove the highlighted columns from the Pivot table and to display only the Parent folder and its highest size occupying  Level1 child folders along with there sizes.

Ouput_PivotTable.PNG

A quick response would be much appreciated.

Thanks a lot !

2 Replies
tajmohamed30
Contributor III

Re: Calculating the size of each subfolders/files and mapping the back to parent folder.

pls look at the document analyzer you may have some idea QlikView Document Analyzer v3.5 Available

jake_qlik
New Contributor

Re: Calculating the size of each subfolders/files and mapping the back to parent folder.

Thank you Taj !

But the Document Analyzer is a little bit complex to understand for Now.

If possible could you point out the mistake that I am doing in my attached script.

Community Browser