topic Re: reduce Load on charts in QlikView

reduce Load on charts

Tue, 14 May 2013 04:51:29 GMT

My application takes 4 minutes to get reloaded,

applications contains 15 sheets in every sheet have 10 charts, whn i surf through the report it takes time to get the data refreshed in the chart

how can i minimise the load,

m using SUM in maximum expressions..

hw can i reduce the load...

Any suggestions.

Re: reduce Load on charts

Anonymous — Tue, 14 May 2013 04:58:02 GMT

You can reduce the data in your application..

Select any one data in any field eg. Select 2007 in the year field, then go to file --> Reduce Data---> Keep Possible values.

Thus the application is limited to the selcected data alone.

Now reloading will be quick compared to the old one..

Hope it helps u

Regards

Revathy

Re: reduce Load on charts

Tue, 14 May 2013 05:00:47 GMT

Thks Revathy,

reloading is not a problem, the user whn surf through the sheets, it takes max time to get loaded with data in the chart

Re: reduce Load on charts

Tue, 14 May 2013 05:03:01 GMT

Are you trying to show case all the charts in the screen at the same time.

Regards,

Nitin Jain

Re: reduce Load on charts

Tue, 14 May 2013 05:05:31 GMT

Yes thts the requirement and moreovr all charts contain 7 to 8 expressions wherein have used SUM so groupimg is causing the problem, hw cn i reduce the load..........

Re: reduce Load on charts

sushil353 — Tue, 14 May 2013 05:07:43 GMT

Hi,

there are many things which are related to the performance of the report.

1. is your qvw file is big in size as compare to the RAM you have in your system or server?

2. are you using too many conditions in your chart to calculate the expressions.?

3. do u have unneccessory field in your data model which are not at all required for the analysis.?

4. is there any data modelling issues like circular loop, synthetic keys etc...

5. are u using too many text objects in your application ..

take care while creating app or data model it is going to affect your app performance.

HTH

Sushil

Re: reduce Load on charts

Tue, 14 May 2013 05:22:20 GMT

Any more suggestions please.....

Re: reduce Load on charts

Wed, 22 May 2013 04:04:32 GMT

Hey Guyz,

m still stuck at it, please give me some suggestions......

Re: reduce Load on charts

suniljain — Wed, 22 May 2013 05:15:33 GMT

It may be issue of data model and complex expression used in chart . other than that I do not think any factor resoponsilbe if your dashboard refreshed in 4 minutes.

Regards;

Sunil

Re: reduce Load on charts

Wed, 22 May 2013 05:23:41 GMT

Hey Sunil,

Do variables causing problem,

as many variables have been used for calender operations.

Re: reduce Load on charts

jjordaan — Wed, 22 May 2013 06:50:40 GMT

What is the purpose of that chart?

What I mean that if that chart gives specific insight of a customer you can make the chart visible when there is only one customer selected.

Count (DISTINCT CustomerNo) = 1

Re: reduce Load on charts

Wed, 22 May 2013 07:15:26 GMT

No its viewable Nationwide almost 100 users at a time......

Re: reduce Load on charts

jjordaan — Wed, 22 May 2013 08:37:23 GMT

But is it possible that the chart will only be visible if you select one customer for example?