Hi Team,
I have a Qlik Sense report with a single table having 2.5 million records (with 4 Dimensions and 3 Measures). After reloading the report, I am facing a performance issue, it is taking nearly 8-12 seconds to refresh the table chart, and for sorting the data for the first time with different dimensions I can see a delay of 8-12 seconds.
Is there anyway to improve the performance of the report.
Below is the query to Load the dummy data
TBL_Test:
Load
'D1_' & floor(Rand() * 10000) as D1,
'D2_' & floor(Rand() * 100) as D2,
'D3_' & pick(ceil(Rand() * 6),'A','B','C','D','E','F' ) as D3,
'D4_' & pick(ceil(Rand() * 7),'-3','-2','-1','0','1','2','3' ) as D4,
Rand() * 150 as M1,
Rand() * 250 as M2,
Rand() * 500 as M3
AutoGenerate 2500000;
I have attached QVF file with dummy data for reference.
Version : Qlik Sense February 2022 Patch 9
