topic Hidden Objects effect performance? in QlikView

Hidden Objects effect performance?

Mon, 07 Apr 2014 20:16:26 GMT

Hi I have lets say 40ish objects on one sheet and 25ish of them are Charts. Most of the objects are hidden though and only a few are displayed at one time. However these objects aren't the quickest and that could be becasue of a few things. One thing I was wondering though is if having 20 objects that are hidden could affect the performance?

Thanks,

Bryan

Re: Hidden Objects effect performance?

Miguel_Angel_Baeyens — Mon, 07 Apr 2014 20:28:28 GMT

Hi,

No, hidden objects are not calculated. However, if they have a very complex, say, several nested if() in their show/hide condition, that might affect, as any click requires all the show condition to be refreshed in case they should change their state.

Is that the case?

The easiest way to test whether or not they are impacting performance is moving those hidden objects to a new, hidden sheet.

Miguel

Re: Hidden Objects effect performance?

chiru_thota — Mon, 07 Apr 2014 20:30:40 GMT

QlikView performance tuning

Re: Hidden Objects effect performance?

Mon, 07 Apr 2014 20:40:56 GMT

Yes that is the case. They aren't heavy If's but there are a lot of them. I'll go ahead and test what the timing is when the other objects are on a different tab.

Thanks for the help