Is there any way to temporarily disable recalculation while developing a file? I am working with a very large dataset in a fairly complex workbook and some tabs can take over 30 sec to recalculate. When I am flicking back and forth between tabs to check expressions or chart properties, this is very frustrating as I do not need to see the actual results, just the properties of each object.
Tableau and Excel both have functionality that can disable updates which I have found very useful while developing. In QlikView it appears that I can only press the red (X) alongside the calculating progress bar, which works to an extent but tends to be slow to respond itself as the processor is too busy to register the interrupt.
Am I missing something else, or are there any easy workarounds?
You can detach an object to suspend recalculation (on the General tab of sheet object properties). But this setting is not persistent.
For a more persistent solution while developing, you can reduce the data that's loaded (FIRST 1000 on SQL Server, or in debug mode in QV), or you can set a conditional calculation on the problem objects, so that they only calculate if the number of rows is small.
Finally, if you minimise the object, it will not be calculated. Nor will any objects on sheets other than the current one.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein