Is there a guide to using the the QS document analyzer? For example, while drop fields seems intuitive (not using it drop it from the code) what does 1: 'Suboptimal numeric storage', actually mean?
I was hoping to interpret the results for non-data people so a good non-technical guide would be useful.
That warning is telling you that Qlik is using more memory to store the field than you might expect. I'll skip over whythat might be, but if you force a sensible numeric format onto the field in the load script you should see the memory usage go down and the warning disappear - something like:
num([fieldname], '0.00') as fieldname
To give you an idea, in one of my Apps I had a currency value which was had a Symbol Width of 28.62, using 10Mb of Symbol Bytes. With the above code that dropped the width to 8 (as you would expect it to be) , and the Symbol table entry to 2.8
So it can be a big saving - the Symbol Width and Symbol Bytes column will tell you whether a field is worth fixing.
That warning is telling you that Qlik is using more memory to store the field than you might expect. I'll skip over whythat might be, but if you force a sensible numeric format onto the field in the load script you should see the memory usage go down and the warning disappear - something like:
num([fieldname], '0.00') as fieldname
To give you an idea, in one of my Apps I had a currency value which was had a Symbol Width of 28.62, using 10Mb of Symbol Bytes. With the above code that dropped the width to 8 (as you would expect it to be) , and the Symbol table entry to 2.8
So it can be a big saving - the Symbol Width and Symbol Bytes column will tell you whether a field is worth fixing.
