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.

[#2]

pls cross check ur data model once  and chart expressions

[jyothish8807]

HI Due,

I guess this is because of huge amount of data and your chart is not able to hange it.Try to filter it out for some small amout of data.

for eg. for last month or for particular day.Check is the chart is working or not.

sum({<Date={'1/12/2013'}>}Sale) something like this or simply selet the dates from the list box for testing.

Regards

KC

[#4]

My model is easy enough: 1 Fact table and 1 dimension table. The chart (line chart) maybe a little complicated.

I used a caculated field to show the top n, it is like :

     if( aggr(rank(sum(Sales)),Brand) <= vTop,Brand). (vTop is a variable that can be adjusted by users. )

I have only 1 expression which is pretty simply.

Is the calculated dimension that cause this issue?

[danieloberbilli]

Seems that you have a very performance heavy / not optimized expression or a (too) complex condition in the Calculation Condition (General tab)  or Conditional Shows of Dimension or Expressions. Could you post your expressions?

[danieloberbilli]

In this case I recommend to set a condition on the General Tab > Calculation condition - where you wait e.g. for a entry of the user in vTop - then you can have a personalized error message saying e.g. ' Please select a Rank'

[danieloberbilli]

I think Calculated Dimensions like this one are very performance heavy

[#8]

Thank you. I will have a test through adding a filed selection trigger when opening. And if it is the reason i will make you answer the correct one.

[#9]

Thank you. But i don't think i will take you advice because i want users to see the chart at the first sight.

[#10]

As i have known, it is better than setting in "Dimensions Limits" tab.