If you are a Qlik Cloud (SaaS) customer you may have seen this dreaded message during script reload. Ack! Ack!
![](https://i0.wp.com/qlikviewcookbook.com/wp-content/uploads/2024/05/image.png?w=1200&ssl=1)
Your quota may be different than 25Mb, but the problem remains the same. How do I modify this application to fit within my subscribed quota?
QSDA Pro V3.1 to the the rescue! QSDA analyzes your app and provides recommendations and easy to use tooling to drop unused data and optimize the remaining data, potentially greatly reducing the size of your Qlik App.
QSDA needs a successfully loaded app for analysis, so our first step is to reload the app using the “Limited load” feature of the Qlik script debugger.
Click the Debug button in the Qlik script editor, check the Limited load option, accept the default of 100 rows and click “Run” to initiate the reload. The reload will come in under your quota. When the reload completes, key Ctrl-s to persist the data.
You don’t have a business-ready app, but this is enough for QSDA to scan all charts, expressions and master items to determine what data is actually required.
![](https://i0.wp.com/qlikviewcookbook.com/wp-content/uploads/2024/05/image-2.png?w=1200&ssl=1)
In QSDA Pro we now select our Cloud connection and select the app of interest, in this case “BikeShop Sales2”. Click the “Open” button to prepare the app for analysis. I will also uncheck the “Collect Calctime” option because chart calculation times are not meaningful with our limited data. Description is optional, in this case I’ve entered “Limited Load”.
![](https://i0.wp.com/qlikviewcookbook.com/wp-content/uploads/2024/05/image-3-1024x328.png?resize=1024%2C328&ssl=1)
Click the “New Analysis” button to launch the QSDA Pro analysis. The analysis may take a minute or two to complete depending on the capacity of your tenant and the current Qlik Cloud load. When the analysis is complete press the “View” button to see the results.
![](https://i0.wp.com/qlikviewcookbook.com/wp-content/uploads/2024/05/image-5-1024x112.png?resize=1024%2C112&ssl=1)
![](https://i0.wp.com/qlikviewcookbook.com/wp-content/uploads/2024/05/image-6.png?w=1200&ssl=1)
QSDA provides a Script Generator in the Tools menu to generate a “DROP Fields …” script statement for unused fields. Select the script generator from the Tools menu.
![](https://i0.wp.com/qlikviewcookbook.com/wp-content/uploads/2024/05/image-7.png?w=1200&ssl=1)
In the Script Generator > Drop Fields tab select the top checkbox to select all recommended fields. Press the “Copy” button to copy the generated Drop Fields statement to your clipboard.
![](https://i0.wp.com/qlikviewcookbook.com/wp-content/uploads/2024/05/image-8-1024x486.png?resize=1024%2C486&ssl=1)
Paste the Drop Fields statement at the end of your Qlik Script and reload.
![](https://i0.wp.com/qlikviewcookbook.com/wp-content/uploads/2024/05/image-9-1024x744.png?resize=1024%2C744&ssl=1)
Reload successful! Victory!
A subsequent QSDA analysis shows the app size has been reduced from the problematic 37Mb to 15MB!
![](https://i0.wp.com/qlikviewcookbook.com/wp-content/uploads/2024/05/image-10-1024x92.png?resize=1024%2C92&ssl=1)
QSDA Pro can quickly and efficiently get your Qlik Apps below your Qlik Cloud quota by pruning unnecessary data. Don’t pay for more than you need.
In a follow up post I’ll walk through some additional QSDA features to help you reduce Qlik app footprint even further and improve chart response time to boot.
Download QSDA Pro and try it for yourself. Or reach out to us to learn more about license options or arrange a demo or POC for your team.
-Rob