Getting "Allocated memory exceeded" with Dimension Limits with 2 chained expressions
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!
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.
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.
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...
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.
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.
