topic Re: Optimization in QlikView

Optimization

Nagaraju_KCS — Sat, 31 Aug 2013 07:15:44 GMT

Hi Community,

i have a Pie chart not only pie chart it takes reload time 15 sec, i want to reduce time below 10 sec..

any technique..

Thanks..

jjordaan — Sat, 31 Aug 2013 07:23:53 GMT

You need to give us a bit more information.

1. What is the amount of data

2. How many dimensions do you use

3. What is the unique ness of the dimensions

etc

Nagaraju_KCS — Sat, 31 Aug 2013 07:28:48 GMT

Hi ,

I have 1 dimension(Month) and 3 expressions in Combo chart..

500 Mb data

jjordaan — Sat, 31 Aug 2013 07:47:42 GMT

Are these expressions relatively simple like Sum(field) or more difficult witth Aggr, Set Analysis.

Try to make the expressions less CPU consuming as possible.

rajeshvaswani77 — Sat, 31 Aug 2013 10:11:46 GMT

Hi Raju,

15 seconds is very high a load time. In case you are having set analysis, see if you can take it to script level. Then it will load instantly.

thanks,

Rajesh Vaswani