Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Will a Hidden object consume server memory while the user access the particular sheet, where this hidden object is present? or is it like a minimised object.
This hidden object a Pivot table which will be shown only on a filter selection. The hide condition is set in layout tab.
Can someone pls help with this?
-Sundar
Hi
I doubt that memory consumption is causing poor performance in your dashboard, unless your server has too little RAM for your application.
I would look at the structure of your model -
Is your data model a well formed star schema, or is it more complicated?
Are the tables associated using a single key, or a simple composite key?
Are there a lot of rows in tables that are not associated with any other tables?
And the expressions -
Do you use calculated dimensions (especially if these could be replaced by derived fields during load)?
Do you use sum(if()) structures or similar structures requiring massive joins
Are your expressions very complex (Pick(Match()) or deeply nested If() statements, many terms...
Any of these can cause performance issues, especially when the fact table(s) contain millions of rows.
HTH
Jonathan
Hi All,
Any thoughts please......
Hi,
Hidden objects won't consume memory, you can test like this.
Step 1: For unhidden object
Sheet Properties -> Objects-> Check the corresponding Object Memory value.
Step 2:
Now hide the object by using Chart Properties -> Layout -> Show - Conditional = 0
Now check memory size
Sheet Properties -> Objects-> Check the corresponding Object Memory value.
you will get memory size as 0.
Hope this helps you.
Regards,
Jagan.
is it calctime or memory?
Hi,
Calctime is for calculation time and Memory is for memory occupied, in your case it is Memory.
Regards,
Jagan.
Hi jagan,
I tried out what u have suggested in Step1 and step2 above, Looks like there is no change in memory for a object when it is hidded or shown. Only the calctime changes to zero when i hide the object. Does that mean hidden object takes ram? Pls suggest..
-Sundar
No , it will also not take any memory while hidden.....
Hi
A hidden object may consume memory. If it has been un-hidden at some point, then it will have been calculated, and the calculation results would be stored in cache memory. I don't think that the cache would be cleared if the object is hidden again using an action. Perhaps someone from Qlik would like to add to this discussion.
HTH
Nitin,
I have a pivot table which will return me millions of rows by default. In layout condition I have given a condition to make to chart pop up only if a shop is selected. with a single shop selected it would be only hundred rows in pivot table. My Dashboard porformance is not good. Do u think this hidden pivot table takes ram and makes the dashboard perform slow. Am aware of "calculation condition" in general tab. But i have not give any condition to it. Will a hidden object take memory for calculations on user selections? what if the user selects a country? will my pivot table which is hidded consume memory?
Pelase advise..
-Sundar
Until the object is hidden (Layout>Show>Conditional),
It do not take RAM .
The abject will be calculated only when it is shown......