Qlik Sense Straight Table rendering very slow

Gowtham — Sun, 05 Jan 2020 06:56:57 GMT

Hi All,

In my application, I have one Straight table which has more than 10 dimensions(without measure) and it has millions of entries. When I apply the filter the table is loading for a long time to render the chart.

Can anyone tell me how to optimize the table to resolve the performance issue?

Thanks in advance

Re: Qlik Sense Straight Table rendering very slow

Kushal_Chawda — Thu, 17 Oct 2024 13:12:05 GMT

If you have millions of records in a straight table, it will likely render slowly because the table contains many dimensions, and associating each value can take time. Below are some tips to improve performance:

Limit the data in the straight table:
You can either reduce the dataset size (e.g., load only 2 years of data instead of 5) or remove key fields from the straight table, as these can significantly slow down rendering.

Apply a calculation condition on the straight table:
This forces the user to make a selection before the data is displayed. By filtering the data first, the table will render more efficiently.

Ensure key fields are optimized:
If the fields in the table come from different tables, make sure the key fields between them are correctly associated and not stored as text. If a key field is text, consider converting it to a number using theautonumber or autonumber# function.

Remove calculated dimensions:
If you’re using calculated dimensions in the table, move those calculations to the script instead. This will reduce the load during rendering.

Increase server RAM:
As a last resort, you can increase server RAM to improve performance, but this option may require extensive checks and approvals before implementation.

Re: Qlik Sense Straight Table rendering very slow

Gowtham — Mon, 06 Jan 2020 04:21:39 GMT

Thank you,

I will try these and let you know

topic Re: Qlik Sense Straight Table rendering very slow in App Development

Qlik Sense Straight Table rendering very slow

Re: Qlik Sense Straight Table rendering very slow

Re: Qlik Sense Straight Table rendering very slow