Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Thank you for you patience and suggestion. But i think this will make it more complicated. I won't take this. Thank you.
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))
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!
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.