topic Re: =Max(..) in chart expression causes "allocated memory exceeded" in QlikView

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

Tue, 20 Oct 2015 14:43:10 GMT

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 — Tue, 20 Oct 2015 14:52:46 GMT

Hi John

These documents in might help you find your answers:

Regards,

marcus_malinow — Tue, 20 Oct 2015 14:56:14 GMT

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