Q&A with Qlik: App Optimization

Troy_Raney — Wed, 25 Mar 2026 10:22:11 GMT

Join Qlik Support's office-hours, recorded live, where our experts answer your questions and give more insight on our App Optimization.

Questions:

01:31 - How to find the sheet or object loading time?
03:20 - Is separating data and visualization scripts a good strategy?
05:16 - How to identify fields that are not used?
06:25 - Is there an operator that should be used instead of IF?
08:46 - How to optimize an app with a large data set?
10:42 - Does having one large fact table perform better?
12:38 - Are QVDs faster to load from?
14:27 - Will it be possible to copy/paste multiple objects at once?
16:09 - Is there an App Analyzer for QlikView?
17:49 - Should using HIDE when NULL improve performance?
20:30 - What type of data model is best for historized fact tables?
24:44 - How to only load updated files?
27:05 - Does Section Access affect performance?
29:00 - Does having a lot of sheets affect performance?
31:15 - Does tagging a field "Hidden" reduce the app size?
32:36 - Do Parquet files load faster than QVD files?
34:07 - How to monitor capacity consumption?
36:08 - Can loading directly from a source be faster than QVDs?
37:40 - How to allow selecting blanks in a straight table?
39:16 - Can lots of security rules affect app performance?
41:19 - When is ODAG necessary?
43:22 - Is using a default bookmark recommended?
44:55 - Do multiple concurrent users affect performance?
47:07 - Why has the reload summary changed?
48:46 - Should Section Access be the last sheet in the script?
50:30 - How to plan the capacity for a load?
51:49 - How to easily change the column order in a straight table?
53:32 - How to best use the AGGR function?
54:48 - Can you limit the number of sheets a user can create?
56:46 - Can data islands decrease performance?
58:06 - Does using variables in Set Analysis affect performance?

Resources:

Did we answer your question? Let us know by clicking the like button!

Click here to see video transcript

@banderson735

@EamonnH

topic Q&A with Qlik: App Optimization in Techspert Events

Q&A with Qlik: App Optimization