=Max(..) in chart expression causes "allocated memory exceeded"

[#1]

If I have a Chart dimension containing Max(..), the chart displays "allocated memory exceeded".

If I replace Max(..) with a variable that is defined as Max(..), the chart displays properly.

Is this a bug in QV or in my usage?

expression that does not work:

=IF( (YM + 103 ) >= Max(YM),

  FYear & '-' & CalendarMonth,

  Null()

  )

Expression that works:

=IF( (YM + 103 ) >= $(vMaxYM),

  FYear & '-' & CalendarMonth,

  Null()

  )

John

QV 11 SR9

[miguelbraga]

Hi John

These documents in might help you find your answers:

The Magic of Variables

Variables in QlikView | Learn QlikView

Regards,

MB

[marcus_malinow]

Hi John,

it might be useful to see an example document, but I have a couple of observations to start with anyway.

First off in your first expression, have you tried

=IF( (YM + 103 ) >= $(=Max(YM)),

  FYear & '-' & CalendarMonth,

  Null()

  )

I'm not sure if there might be an issue with the aggregation within your dimension.

Secondly, and probably more significant:

Have you tried changing your expression?

In the set for your expression you could add something like

YM={">=$(=Max(YM)-103)"}

That way you may be able to do without a calculated dimension, or at least change your calculated dimension to just FYear & '-' & CalendarMonth

, which would be preferable.

Marcus