2 Replies Latest reply: Jun 5, 2017 9:56 AM by Jake Parker RSS

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

    Jake Parker

      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 [C:\ or any path] 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 !