I am recently having performance issues i.e. taking a while to switch sheets and then loading graphs once in that sheet?! Can anyone out there advise what to change or look out for and if there are any tools out there that would tell me what data to clean up?
Well, look for the amount and complexity of sheet objects. Under Settings > Document Properties > General, you can export Memory Statistics that should show you how long it takes to load certain objects etc.
Hi Kaushik, I have opened the QlikView Optimizer, when I have gone to my Document to save the mem file it does not save this as that file type but saves this as a text file? when i cahnge the text file from .txt to .mem, the QlikView Optimizer does not look like it recognises the file as the results are not telling me much.
For some reason it is not savingthe file as a mem extension but saving it as the following "Performance..txt" I have changed this to "Performance..mem" and seems to be working now as before I had the file as "Performance.mem".
Do you know what each field relates to?
Also for some reason it is not bring across the CalcTime and AvgCalTime?
Is there anywhere that would tell me which field is not being used within the Document? As I can remit this out when loading the Document.
I tried to save in .mem type but while opening the mem file type it doesn't give any option to open with or can say no support for open. how can we use that file as performance optimizer. Please explain.