topic Calculation Time Out Error for Bar Chart in QlikView

Calculation Time Out Error for Bar Chart

Heena — Sat, 16 Nov 2024 20:10:45 GMT

Hi All,

I have below records:

B_ID Count: 10000

ST_ID Count:19,00,000

LG_ID Count: 60,000

In script in am using:

Autonumber(B_ID&ST_ID&LG_ID) as New_ID.

In Bar chart expression used is:

Count({<C_status ={1}>}distinct NEW_ID)

Bar Chart is loading very slow and after 2 mins its giving Calculation Time Out Error.

In server we cannot increase the standard time set from 120 s.

Help needed here, Please advice me on this.Thanks in Advance!!

Regards,

Heena Kauser

Re: Calculation Time Out Error for Bar Chart

sunny_talwar — Thu, 29 Aug 2019 10:55:43 GMT

How big is the dashboard in size? I am asking this because is it possible that you have a many to many join which might be making this a huge application which would slow everything on the front end

Re: Calculation Time Out Error for Bar Chart

Heena — Fri, 30 Aug 2019 11:51:21 GMT

Hi Sunny,

Yes, the file size is huge and the application is having historical dates and data as well.

File Size: 3033 MB

Thanks & Regards,

Heena Kauser

Re: Calculation Time Out Error for Bar Chart

Deesha — Thu, 13 Jan 2022 19:20:30 GMT

Hi Heena, Could you please share the resolution? As I facing the similar issue.

Re: Calculation Time Out Error for Bar Chart

XzavierMurray — Tue, 18 Jan 2022 05:00:21 GMT

Hey, i have same issue and still waiting for the answer can anybody suggest what should i do?

Myloweslife

Re: Calculation Time Out Error for Bar Chart

Noa — Thu, 09 Jun 2022 11:33:46 GMT

Hi Heena,

I wonder if you mind sharing the solution for that problem.