Qliview app performance in conditional display

[sonikajain]

Dear all,

My qlikview application has a large number of charts (straight and pivot tables) that are displayed conditionally.

Does putting the condition in the 'Calculation condition' or the 'show condition' mean that the chart will be loaded only  if the condition is satisfied.

Does that improve application performance

Please help.

Thanks,

[#2]

Hi,

Update: See attached document for QVW optimization techniques

QlikView tends to calculate charts only when they are active (maximized or restored from the minimized state). In the case of multiple charts spread on different sheets, calculations on a chart/sheet tend to begin only when the sheet is activated. This means, calculations will not take as much memory when a chart or sheet is not active.

This applies to regular charts (read: chartts without conditional display). Fortunately, this also seems to be the case with charts that are conditionally displayed.  When a chart is set to calculate on a specified 'Calculation Condition', calculations only begin with the calculation criteria is met. This apparently results in better application performance, and is in fact, one of the tricks, to optimize application in the case of large data sets.

In a gist, you are indirectly optimizing the performance of the application by letting it to compute charts only when they are active (visible, in your case).

I have worked with quite large data sets in the recent past and have implemented something similar with positive results, and your results shouldn't be any different

Hope it helps.

Regards,

-Khaled.