Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
It could be your right(max()) that is causing trouble. Try this
right( MAXSTRING (MonthKEY), 2) = '01'
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
I don't understand what I can do that?
Change it to:
if(right(MAX(MonthKEY), 2) = 01, avg({$<MonthKEY={"$(=Max(MonthKEY)-89)"}>}QC_EvaluationResult),
avg({$<MonthKEY={"$(=Max(MonthKEY)-1)"}>}QC_EvaluationResult))
It' s good but label expression not valid
=if(right(MAX(MonthKEY), 2) = 01, MAX(MonthKEY)-89, MAX(MonthKEY)-1)