topic Re: Expression Error in App Development

Expression Error

ms206147 — Mon, 16 Mar 2026 14:46:20 GMT

When attempting to use the following QlikView expression in QlikSense, I get an error:

expression:
='Viewing '&%DateType&' '&%Period&' for '&
IF(%Period='Month to Date',ONLY({<MonthID= {$(=Max({$}MonthID))}>}$(=%Year)&'-'&$(=%MonthDisplay)),
IF(%Period='Quarter to Date',ONLY({<MonthID= {$(=Max({$}MonthID))}>}$(=%Year)&'-'&$(=%Quarter)),
IF(%Period='Year to Date',ONLY({<MonthID= {$(=Max({$}MonthID))}>}$(=%Year)))))

Error:
see screenshot attachment

Re: Expression Error

lennart_mo — Mon, 16 Mar 2026 15:11:27 GMT

Hi @ms206147,

the error seems to lie in the expression $(=%Year). If you look at the evaluated formula you'll see a dash instead of - what i'm guessing - should be a field name.

Re: Expression Error

WeLoveQlik — Mon, 16 Mar 2026 15:14:31 GMT

Try replacing Only() with Max() or MaxString() if those values are loaded as text

Re: Expression Error

ms206147 — Mon, 16 Mar 2026 16:24:29 GMT

Thanks all.

The solution was to remove the $ and the = for the year and month.