Discussion Board for collaboration related to QlikView App Development.
I have a tab within one of my documents which contains a Pivot table of data. The table has 2 dimensions and around 50+ expressions.
when i am open application, it's taking almost 10 to 15 mins time.
Please can you suggestion's..
How to boost performance ??
You can optimized your application in the script part.
1. Create the expression in the script part.
2. Use the variables in expression.
3. Most important part use SET in the expression which is fast and good for presentation.
4. Avoid if condition in the expressions
Do you need 50+ expressions in one chart? Can you split the expressions to different charts on separate tabs?
Can you post a example of an expressions you are using, there may be a more efficient way to get the same results.
Few steps that can reduce the time to prepare the chart (not in priority order):
--Move all possible calculations to the script
--Avoid using Count and/or Distinct
--Avoid IF-ELSE statement, consider using Set Analysis
--Consider using Calculation Condition for the chart
Can you possibly post qvw file but before uploading the file, on the General tab find Calculation Condition and enter 1=0 then save and upload the file. This way when anyone from community download and open the file they won't have to wait 10 - 15 mins and people can understand your request and possibly suggest a solution.
In u r application u r using more expression so use all the expression in a script level and store into a variables,
call the variables in the chart level expression,
If u use the variables in the chart level expression it will reduce the load time of data in chart and it will increase the performance of the application..
Try the following...
Remove all dimensions from the pivot chart. If the chart renders all 50 + expression fine without any dimensions, then the issue may not be your expressions, but the number of values in your dimensions. Back in 09 I submitted a case where the rendering of a Block chart was taking 15 or so mins due to the excessive amount of values my dim consisted of was to much. http://community.qlik.com/message/144151#144151
Another thing to consider is, what happens if the chart is a straight table?