Error in Calculated dimension

[#1]

Hi,

I have Qliview applications in Access point and in all appliactions for Bar and Line chart items I am getting the message as

//Error in Calculated dimension .

This is happening in every Bar and Line chart items.

Could anyone let me know why it is like that please.

Thanks.

[CELAMBARASAN]

Could you post the expression your using for the dimension?

[#3]

Hi,

The Expression is

IF(FiscalWeekSerial >=($(curFiscalWeekSeq)-4) AND FiscalWeekSerial<=$(curFiscalWeekSeq),FiscalWeek)

[CELAMBARASAN]

Expression used in curFiscalWeekSeq?

[#5]

The Dimension expression is

IF(FiscalWeekSerial >=($(curFiscalWeekSeq)-4) AND FiscalWeekSerial<=$(curFiscalWeekSeq),FiscalWeek)

and in Expression tab the expression is

Count(Distinct(CaseID))

[CELAMBARASAN]

Hi,

What about FiscalWeek? and what about curFiscalWeekSeq variable expression?

[tresesco]

Check if all the fields and variables (if any) are still valid, might be some of them are not being created as expected after the recent load. Assuming that, it was working fine sometime back.

[#8]

Yes you are right it's worked perfect some time back today only I am getting this problem and I am not able to see one chart item completely. please help me as I am really confusing here

[#9]

Could you please let me a bit more clear as In the Variables Overview tab I am not able to see any values for FiscalWeek and curFiscalWEeekSeq

[CELAMBARASAN]

I guess curFiscalWeekSeq this would be variable because you have included in the dollar expressions.

And FiscalWeek would be field name. Have you check that.

If possible attach sample app. will check it.