topic Error: Calculation Timed Out in Connectivity & Data Prep

Error: Calculation Timed Out

analytics_cred_dashboards — Mon, 16 Oct 2023 11:23:19 GMT

This error is coming while adding measures in chart or pivot table. Both are not able to load measure values in visualization. For reference, I am also sharing the screenshot of the error while using a BAR chart. I don't know why this error is happening. I have stored the data from Redshift to QVD, then using it. It seems to be some space issue or anything. Please suggest what should I do to sort this error on priority as I am working on a dashboard which has top priority. Please help in this.

Regards

Sachin

Re: Error: Calculation Timed Out

Mario_De_Felipe — Wed, 25 Oct 2023 06:57:08 GMT

This error comes out when Qlik reaches limit of memory or processing. Review if your have correctly associated OrderYearMonth field with order_detail_id field. Otherwise, if your table has high volume of data, count distinct could not be the best way to do the expression, maybe it would be better to use a Flag and SUM it.

Re: Error: Calculation Timed Out

Pablo007 — Thu, 26 Oct 2023 08:25:34 GMT

As @Mario_De_Felipe says maybe your table is so big, try to make it shorter, Make a partial load with just some months, or put a filter on a different sheet like one week and then change to the sheet where you have the chart to see if it works.