Text in Chart cause performance issues in QV 9

Mon, 01 Mar 2010 23:50:57 GMT

We upgraded our QV server and QV professional from 8.2 to 9.0.7320.7 on Win 2003 x64 platform.

In one of the QlikView document we are using Pie charts to display "Top 10" information. These pie charts has 2 lines added through "Text in Chart" -

='Total - ' & Num ( Sum ( Aggr ( If ( rank ( sum ( AM_NET_CVA_ASGN_DELTA ))<= 10 , sum ( AM_NET_CVA_ASGN_DELTA )), ClientGroup )), '$#,##0;($#,##0)' ) & ' / ' & Num ( sum ( AM_NET_CVA_ASGN_DELTA ), '$#,##0;($#,##0)' )

= Num ( Sum ( Aggr ( If ( rank ( sum ( AM_NET_CVA_ASGN_DELTA ))<= 10 , sum ( AM_NET_CVA_ASGN_DELTA )), ClientGroup )) / sum ( AM_NET_CVA_ASGN_DELTA ), '.##%' ) & ' / 100%'

It seems that in QV 9, these lines cause severe performance issues. Pie charts take almost a minute to refresh or in some cases get stuck completely.

We have been advised from QlikTech support to try SR 3. I was wondering if someone can simplify above lines to get better performance? These pie charts work fine in QV 8.2.

I also tried using variables to define these expressions and using those variables in Pie charts as "Text in chart", but no luck..

Thanks in advance for any suggestions..

topic Text in Chart cause performance issues in QV 9 in QlikView

Text in Chart cause performance issues in QV 9