topic Re: Getting "Allocated memory exceeded" with Dimension Limits with 2 chained expressions in QlikView

Getting "Allocated memory exceeded" with Dimension Limits with 2 chained expressions

Thu, 20 Feb 2014 12:25:28 GMT

I have a simple table:

table:
load * inline
[
ID, Value
1,2
2,3
3,4
4,5
1,7
2,8
];

After that I create a Straight Table chart with: Dims: ID; Expr: flg:

if(VL>1,1,0)

VL:

Count(Value)

Everything is OK (table shows exactly what I expect), but as soon as I apply Dimension Limits(Restrict which...- Show only values that are:Greater than or equal to - 1 - exact amount) the app throws "Allocated memory exceeded" in the chart. Actually, I can choose any variant of dimension limit - it will lead to the same result. Qlik 11.2 SR5. What am I doing wrong? Thanks!

Test app

Re: Getting "Allocated memory exceeded" with Dimension Limits with 2 chained expressions

Thu, 20 Feb 2014 12:48:18 GMT

Hi Alexander,

tested in 11.20 SR3. Same: memory exceeded.

But why are you limiting the first row indirectly with the second row? Obviously QV doesn't like that 😉

What about using a Variable=Count(Value) instead? Usable in ervery expression.

Otherwise you should open a support-case.

Hth
Roland

Re: Getting "Allocated memory exceeded" with Dimension Limits with 2 chained expressions

Thu, 20 Feb 2014 12:59:16 GMT

May I know the objective of your column "flg"? It works when I re-order the columns.

Thanks,

Sajeevan

Re: Getting "Allocated memory exceeded" with Dimension Limits with 2 chained expressions

sundarakumar — Thu, 20 Feb 2014 13:12:02 GMT

Hi Alexander,

Yes it is working fine when u promote the second expression, bec that is when the qlikview will know what VL is..

and you will be having only

please not it will be restricting the dimension with the value of VL, if you restrict it as value greater than 1 then it will restrict accoriding to VL value 1,1,2,2 not based on the ID value 1,2,3,4.

-Sundar

Re: Getting "Allocated memory exceeded" with Dimension Limits with 2 chained expressions

Thu, 20 Feb 2014 13:44:50 GMT

I'm a newbie to qlik, so, please, tell me, how should I use a variable? If I add it to my chart it shows a total count of value, not "GROUP BY ID", so it can't be a criteria.

Re: Re: Getting "Allocated memory exceeded" with Dimension Limits with 2 chained expressions

Thu, 20 Feb 2014 13:53:56 GMT

This file is a simplified model. I made it to find out the source of malloc problem. The real task is more complicated and instead of VL was something like that

Count({$<[StartDate]={"<=$(TargetDate)"},[EndDate]={">=$(TargetDate)"},[Type]={1}>}CID)

And I needed to display only lines that have the value between, say, 3 and 6. That was the task of flg to mark them and then kill by dim limits.

If you reorder the columns it will change the basis of dims limits. It will rely on VL when calculating the condition.

Re: Getting "Allocated memory exceeded" with Dimension Limits with 2 chained expressions

IAMDV — Thu, 20 Feb 2014 13:56:28 GMT

Hi,

The reason this won’t because you’re referring to the label name first in the IF Statement (flg) and then you are creating the VL field with count. This order won’t work with Dimension Limits; so change the order of the expressions and everything works (see the attached example).

I hope this helps!

Cheers,

Re: Re: Getting "Allocated memory exceeded" with Dimension Limits with 2 chained expressions

Thu, 20 Feb 2014 13:56:57 GMT

I need the restrictions to be applied based on the namely flg column. And I see now reason, why without the limits Qlik can display flg BEFORE VL, but it can't, when limits are applied...

Re: Getting "Allocated memory exceeded" with Dimension Limits with 2 chained expressions

Thu, 20 Feb 2014 14:04:59 GMT

OK,

In this case I suggest to build a calculated dimension and forget about the easy use of DimensionLimit Tab. This means to put your flag via if() into the definition of the dimension "ID". What about this ?

Re: Re: Getting "Allocated memory exceeded" with Dimension Limits with 2 chained expressions

Thu, 20 Feb 2014 14:07:13 GMT

If you change your expression in "flg" like below it works.

=IF(COUNT(Value)>1,1,0)

The reason for malloc error was due to your evaluation of VL before VL being calculated.

Thanks,

Sajeevan

Re: Re: Getting "Allocated memory exceeded" with Dimension Limits with 2 chained expressions

Thu, 20 Feb 2014 14:08:00 GMT

I don't quite catch, why Qlik can display chart, but can't fileter it out using dims limits. It just an additional operation over the created table...

You solution won't help, because I need to refer to flg, when filtering out the table. Maybe I can implicitly put the definition of VL into flg if() statement. But even if it works, it is an ugly solution, because it will make such definitions much more complicated and harder to edit.

Re: Re: Getting "Allocated memory exceeded" with Dimension Limits with 2 chained expressions

IAMDV — Thu, 20 Feb 2014 14:14:50 GMT

I hear you and totally understand your point. But please remember logical query processing (how we think it will or should work!) is different from actual physical query processing, which is based on clever algorithms to save CPU cycles.

Let me work out a solution without moving the expressions.

Re: Getting "Allocated memory exceeded" with Dimension Limits with 2 chained expressions

Thu, 20 Feb 2014 14:22:51 GMT

It will work as I already wrote as a reply to some other post, but it's really inconvenient as in case of redefining, I'll have to alter all the definitions of VL instead of doing that once. But if no other solution is found I'll have no other way...

Re: Getting "Allocated memory exceeded" with Dimension Limits with 2 chained expressions

Thu, 20 Feb 2014 14:25:06 GMT

I haven't thought about calculated dims and haven't read about it, so maybe I should... Maybe you can provide a working example? Thanks in advance!

Re: Getting "Allocated memory exceeded" with Dimension Limits with 2 chained expressions

Thu, 20 Feb 2014 14:29:42 GMT

Sure! I'll be glad if you do. This isn't that urgent. It's a part of my first project, so it is a hard way of understanding... 😉

Re: Re: Getting "Allocated memory exceeded" with Dimension Limits with 2 chained expressions

Thu, 20 Feb 2014 15:44:48 GMT

The other option is promote VL as 1st item under sort and set the sort by as Numeric Value in a Descending order for limiting the dimensions - if this helps.

Regards,

Sajeevan

Re: Getting "Allocated memory exceeded" with Dimension Limits with 2 chained expressions

Fri, 21 Feb 2014 22:23:13 GMT

It seems I can't refer expressions in calced dimension's definition. I also can't use explicit aggregations like 'Count(Value)' here. The only benefit for me is the ability to filter some plain unaggregated conditions without using expressions for the purpose. Sad.