QlikView performance tuning

[john_duffy]

Hello All.

We have several applications that have sheets with numerous charts that are displayed or hidden based on user selections.  Basically, the user will click on a text box that sets a variable.  The variables are then used in the chart's layout tab Show Conditional setting to determine whether or not the chart is displayed.

Also, a lot of the charts use the Enable Conditional settings for dimensions and the Conditional setting for expressions.

Is there a significant performance hit by using all of these conditional settings?

We are using QV11 SR2.  When I check the sheet's Properties\Objects\Calc Time, the objects that are not shown because of the Show Conditonal setting have a calc time value of zero.  This leads me to believe the Show Conditional setting does not affect performance.  I was going to create separate sheets for he various charts instead of using the Show Conditional setting, however, based on the calc time verification, I don't think this is necessary.

Any feedback would be appreciated.

Thanks,

John.

[chiru_thota · Accepted solution]

Hi Jhon,

Yes.there is performance hit and we faced it.But it depends on how many objects in that sheet.

(1) We had sheet with 3 straight tables showing one at a time depending on the user selection and it works fine as performance hit is very minimal ( 1 second)

(2) We have another report which has more objects (10) in same sheet then we could see performance hit by few seconds (8 to 10 seconds delay) compared with having them in separate sheets.

Bottom line :

Performance hit is purely depends on how many objects and how many conditions you are using.

I guess it is perfectly alright if we have reasonable number of objects in a single sheet and conditionally show/hide.

Qlikview always advise to have them in different sheets instead of having them in a single sheet and conditionally show/hide.But we can't avoid it as per some requirements

Thanks,

Chiru

[john_duffy]

Thanks for the response Chiru.