I'm trying to improve speed of dashboard because there have many data and expression messure existing in the app.
Example Function: Pick, If, Set Analysis, Getselectedcount, Getcurrentselection, Set Analysis
Example Chart: Line Chart, Bar Chart, Dual Chart, Pivot Table, Heatmap
Example Data: 6 Table, 1 of them has 20,000,000 record 28 field, 2 of them has 10,000,000 record, 1 Table has spatial data
I would like to know method that increase proformance of dashboard because it takes time for dashboard processing.
Qlik Sense Hardware spec
CPU
DeviceID NumberOfCores NumberOfLogicalProcessors
CPU0 4 8 CPU1 4 8
Window Server 2016
Ram: 144 GB