topic Chart Calc time is high in QlikView

Chart Calc time is high

santhosh_k_n — Wed, 14 May 2014 06:07:54 GMT

Hi All,

I am facing problem while opening a chart in access point.

I had used a pivot table chart, the sheet has similar pivot tables.

What the issue is the new pivot table is having long calc time if i check in, settings > Doc Properties > sheets

the particular chart is taking a huge time and also through allocated memory exceeded in desktop clint and it not at all getting opened in access point.

Please guide me

Re: Chart Calc time is high

ashfaq_haseeb — Wed, 14 May 2014 06:18:18 GMT

Hi,

It depends on the many factors like.

Data model design
Calculation used
Virtual Server used
Type of expression used
No. of fields used to display in your Pivot table.

May be you have to increase your ram and cpu core. It depends.

Regards

ASHFAQ

Re: Chart Calc time is high

tresB — Wed, 14 May 2014 06:19:30 GMT

I would start from two basic points to trace down the issue:

Check chart expression and try to optimize it if there is any scope
Data model

Re: Chart Calc time is high

jagan — Wed, 14 May 2014 06:30:35 GMT

Hi Santosh,

Try below points

- If you are using any calculations in front end, move it to script and avoid Calculated dimensions if any.

- Use Set Analysis, if any If is there

- Aggr will take more time to evaluate, if you are using Aggr(), try to remove it

- If you are displaying huge data in Pivot, restrict the chart to load only if certain filters are selected.

- Check your Data model, try to make it as Start Schema.

Hope this helps you.

Regards,

Jagan.

Re: Chart Calc time is high

Anonymous — Thu, 05 Mar 2015 11:05:09 GMT

I have like 50 dimensions Im showing in a straight table. how would I go about reducing calc time for this table?

Re: Chart Calc time is high

jagan — Fri, 06 Mar 2015 02:08:28 GMT

Hi Stefan,

Don't display all the records at a times, force user to do some selections in field by using Calculation Condition option in Properties tab using GetSelectedCount()

Example: GetSelectedCount(Year) > 0

Now if user selects year in Year field then only the chart loads.

Regards,

Jagan.