Expression

[kkarlste]

I don't understadt what is wrong this expression

if(right(MAX(MonthKEY), 2) = 01, avg({$<MonthKEY={"$(=Max(MonthKEY)-89)"}>}QC_EvaluationResult),
      avg({$<MonthKEY={"$(=Max(MonthKEY)-1)"}>}QC_EvaluationResult))

[Vegar]

It could be your right(max()) that is causing trouble. Try this

right( MAXSTRING (MonthKEY), 2) = '01'

[rwunderlich]

The error message comes because on the second line you have unicode spaces (xE28082) instead of ascii spaces (x20) leading the line. Delete and retype those spaces in the editor to fix your issue. 

-Rob
http://www.easyqlik.com
http://masterssummit.com
http://qlikviewcookbook.com

[kkarlste]

I don't understand  what I can do that?

[rwunderlich]

Change it to:

if(right(MAX(MonthKEY), 2) = 01, avg({$<MonthKEY={"$(=Max(MonthKEY)-89)"}>}QC_EvaluationResult),
avg({$<MonthKEY={"$(=Max(MonthKEY)-1)"}>}QC_EvaluationResult))

[kkarlste]

It' s good but label expression not valid

=if(right(MAX(MonthKEY), 2) = 01, MAX(MonthKEY)-89, MAX(MonthKEY)-1)