Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to check the folder size


is it possible to verify folder size or not?

1 Solution

Accepted Solutions
vikasmahajan

Try with this macro

SUB DoDir (Root)

    FOR Each Ext in 'qvw', 'qva', 'qvo', 'qvs'

        FOR Each File in filelist (Root&' \*.' &Ext)

            LOAD

                '$(File)' as Name,

                FileSize( '$(File)' ) as Size,

                FileTime( '$(File)' ) as FileTime

            autogenerate 1;

        NEXT File

    NEXT Ext

    FOR Each Dir in dirlist (Root&' \*' )

        call DoDir (Dir)

    NEXT Dir

ENDSUB

CALL DoDir ('C:')

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

View solution in original post

2 Replies
vikasmahajan

Try with this macro

SUB DoDir (Root)

    FOR Each Ext in 'qvw', 'qva', 'qvo', 'qvs'

        FOR Each File in filelist (Root&' \*.' &Ext)

            LOAD

                '$(File)' as Name,

                FileSize( '$(File)' ) as Size,

                FileTime( '$(File)' ) as FileTime

            autogenerate 1;

        NEXT File

    NEXT Ext

    FOR Each Dir in dirlist (Root&' \*' )

        call DoDir (Dir)

    NEXT Dir

ENDSUB

CALL DoDir ('C:')

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.
Not applicable
Author

Yes, you can check by using macro and also by Load statement.