Convert file sizes - bytes kilobytes megabytes terabytes

[C1109]

Hi all, 

I'm fairly new to Qlik and struggling with an issue I hope someone can help with...

I have a spreadsheet loading into Qlik containing file sizes in Megabytes. If possible I would like Qlik to automatically select the most appropriate units in a visualisation when multiple rows are selected.

Have tried using manual calculations based on other threads I've found but these are very confusing. Surely Qlik is smart enough to do the work for us in this sense?

[EnriqueMartinez]

This method works for me:

Dual(

        If(size_bytes >= Pow(1024,4), Num(size_bytes / Pow(1024,4), '#,##0.00') & ' TB',

        If(size_bytes >= Pow(1024,3), Num(size_bytes / Pow(1024,3), '#,##0.00') & ' GB',

        If(size_bytes >= Pow(1024,2), Num(size_bytes / Pow(1024,2), '#,##0.00') & ' MB',

        If(size_bytes >= 1024, Num(size_bytes / 1024, '#,##0.00') & ' KB',

        Num(size_bytes,'#,##0') & ' Bytes')))),

        size_bytes)

        As human_readable_size,