Charts don't show when opening

[#1]

Hi all,

    Many times i opened my 1 specific .qvw file, below piture shown at where there should be a chart. Any action will make it normal, like selecting, switching sheet, clicking buttons etc. Why this happen and how to avoid this? Thanks in advance.

[danieloberbilli · Accepted solution]

Another way could be: you first show a copy of the chart with a normal dimension (like a standard / default value of vTop) to make sure that it will always be shown in the correct way. And in the moment the user does a selection - you hide the standard chart and show your real (dynamic) chart

[#3]

Thank you for you patience and suggestion. But i think this will make it more complicated. I won't take this. Thank you.

[danieloberbilli]

One last idea: instead of having the calculation in the dimension, move the calculation in the expression:

so Dimension  = Brand

and Expression = if(aggr(rank(sum(Sales)), Brand) <= vTop, sum(Sales))

[#5]

Thank you very much. You mean calculate in the expression will be less heavy ?

Anyway, I finnally take you advice : when opening, show the chart containing total Brand and if chage the vTop then show the heavier one. I think it is necessary to let users to see the all Brands first.

Thank you and cheers!

[danieloberbilli]

Yes, definitely - calculations within Calculated Dimension are always heavier than in expressions. I try to avoid those as much as possible and rather try scripting a solution in the backend.