Conditional show

[#1]

Hi,

If we are creating objects with conditional show (chart objects or the pivot objects).  How does it function. When the object is on hide state still the expressions will get calculated and the system resources will be used for hidden chart objects as well or the expressions will get calculated only when it is shown .

[its_anandrjs]

Hi,

No all the functionality and conditions showns when they are visibles.

Rgds

Anand

[#3]

I haven't found a document from QlikTech which outline my observation, but as per my experience the resources were used only when it was visible in the system. If you want to restrict the calucation of chart when they are not visible I recommend using the same expression in Properties>General>calculation condition.

[IAMDV]

Hi,

I might be wrong but this is just my understanding and observation. I think objects are evaluated by QV engine irrespective of whether they are shown/hidden. I have tested with loads of hidden graphs and QV still seems to be calculating for the graphs. And I think that charts are not calculated while they are minimized compared to while they are hidden.

Logically, if they are hidden and if QV is not calculating the chart expression(s)... how will it know when to unhide/show the chart? I mean it has to check to boolean condition everytime the QV engine calculates. And my other experience is that having multiple minimized charts in a sheet is faster than the hidden charts.

I hope this makes sense.

Cheers - DV

[#5]

Hi DV,

    This was the exact concern.But how to check the expression are getting calculated or not when it is hidden.

[IAMDV]

Hi... Its too late now. I will  try to post an example tomorrow. cheers -DV

[IAMDV]

Hi Lokesh,

I have performed some tests with 3 different charts. And these charts have complex expression with Concat() functions. And surprised that hidden charts are not consuming any additional overhead compared to the Minimized chart. Only additional overhead is evaulting the boolean expression of whether chart should be hidden or shown. So minimized charts consumed the lowest resources (memory). I have used the GetObjectCalcTime in the SheetObject class.

Below is the code :

Sub Obj_Calc_Time

     set so = ActiveDocument.GetSheetObject("CH01")

     t = so.GetObjectCalcTime

     msgbox(t)

End Sub

Sorry, I can't post the example because of confidential data.

Sorry, this is the best I can provide.

Good luck. I hope this helps!

Cheers - DV

[#8]

Thanks DV ,

It was helpful to differentiate the resource usage between Minimized and hidden objects.