topic Re: Conditional show in QlikView

Conditional show

Thu, 15 Sep 2011 15:45:46 GMT

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 .

Conditional show

its_anandrjs — Thu, 15 Sep 2011 16:02:20 GMT

Hi,

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

Rgds

Anand

Re: Conditional show

Thu, 15 Sep 2011 16:12:49 GMT

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.

Re: Conditional show

IAMDV — Thu, 15 Sep 2011 17:46:38 GMT

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

Conditional show

Thu, 15 Sep 2011 20:09:16 GMT

Hi DV,

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

Conditional show

IAMDV — Thu, 15 Sep 2011 20:34:27 GMT

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

Re: Conditional show

IAMDV — Fri, 16 Sep 2011 14:38:10 GMT

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

Conditional show

Fri, 16 Sep 2011 16:43:43 GMT

Thanks DV ,

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