Allocated Memory Exceeded

[sunny_talwar]

Hi Qlikers,

I have an issue where I have designed which looks and works perfectly until I close it down and reopen it to see "Allocated Memory Exceeded on some of the charts. Then when I reload the application, everything comes back and as long as I don't close the application, things look fine, but if I close it again the problem comes back. I saw a similar post Allocated memory exceeded on the community, but the solution is not very helpful as I wouldn't want to reload my application every time I open it.

Is there a way to trouble shoot what exactly is the problem here?

Any inputs would be greatly appreciated.

Best,

Sunny

[MK_QSL]

Try to check the dimension and expressions you have used in your table or chart...

Sometimes due to join fails between tables and still you are using different tables fields in your same table, this problem occurs.

You can do save as the application and only load 10 or 20 rows for each tables using Limited Load...

Now analyse whether the Chart/Tables giving correct result or not...

My guessing is due to Cartesian Join/Product this is happening... !

[sunny_talwar]

Thanks for quick response Manish Kachhia‌. My data model looks like this (hidding the table names and fields, but you will see how the basic structure is)

Does this has something to do with the error?

I have only 64 rows of data in that Fact Table.

[Anonymous]

in your data model two tables are stand alone .. Are you using any field from those table in your charts calculation or dimension ?

Thanks

BKC

[sunny_talwar]

I am using the fields from the top data Island table.

[MK_QSL]

Looks like your island table is making Cartesian product.

Can you provide the expressions your have used?

[sunny_talwar]

Edits in Red

The problem seems to be related to a variable I have created which use Match and Pick function:

(If(Match(FieldfromDataIslandTable, 1, 2, 3), Pick(Field1fromGroupedTable, 100, 150), 0) +

...

IfMatch(FieldfromDataIslandTable, 1, 2), Pick(Field6fromGroupedTable, 100, 50), 0))/

(If(Match(FieldfromDataIslandTable, 1, 2, 3), 1, 0) +

...

If(Match(FieldfromDataIslandTable, 1, 2), 1, 0))

Is there anything wrong with the above structure?

Best,

Sunny

[sunny_talwar]

That might be true, but why is everything perfectly fine once it is reloaded?

[MK_QSL]

Can't tell you without looking more detailed version..

[Anonymous]

Sunny because of many if statements in the front end it is using more resources when you first open the app. because the more resources will be consumed when you first open the app. Once the app is opened and if you reload it will not take more resources to populate the data.My first suggestion and best would be push if statement logic into script so that way it will not consume more resources. Second suggestion is increase the RAM of your machine where you are developing the app. Hope that helps.