HOW TO IMPROVE THE QLIK DASHBOARD PERFORMANCE ON MANY DATA AND EXPRESSION MESSURE EXISTING IN THE APP?

[Kridsanapong_sa]

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

[tresesco]

@Kridsanapong_sa ,

There are many such documents in this community available that could guide you in general, that talks about best-practices and optimization techniques. Go through them (if already not done). Otherwise, without getting into your application, not knowing about it - it would be near to impossible to help you specifically on it.