Detail sheet response time

[jjustingkm]

I have a dashboard that has around 4 million records, there is a detail sheet with 4k records but when go to the detail there is a lot of wait time, is it possible to reduce the wait time. 

[micheledenardi]

The response time of qlik object depends from multiple factors, but the most important are 2:

1) datamodel structure

2) calculated dimension and expression complexity of measure

If you want to speed-up your object recalculation make sure you're applying the best practice for both factors.

Using Google you can find hundreds of thread about these topics

[jjustingkm]

But in this case there are a few limitation to apply that in the data model level, is there anything can do if we just bring only a subset of data to the sheet at the sheet level.