out of Object Memory

[Anonymous]

I have an application of size around 3 MB which has around 12 tables.I made a straight table in the front end ,table is working fine unless I click on clear selections button and it shows the message "Out of Object Memory" when i take few selections table is working fine...

I have made few calculations in the table in the expressions and calculated dimensions.

How do I deal with this problem??

[Anonymous]

I have created a table with calculations in the frontend...is there a way I can store it in QVD and then just fetch this data into QVW so the calculations are performed just once and then the records are just read from that QVD into this QVW and the memory does not go out of range..I know the concept of binary load but if I could store it in a qvd is that possible??

[avinashelite]

as per your problem statement, yours is a 3MB application so I don't think its the data size issue, its purely the way your writing the  expression is resulting in the OUT OF MEMORY. May be your expression is ambiguous and Qlikview is not able to resolve it , try to break your expressions into parts then try to check which portion is causing the issue!! this way you will get to know the root cause . Then think whether we can push this to script level or we should handle it in the SQL etc.

Try to paste your script, data model and expression that is will help us to identify the problem .

[Anonymous]

Guys I got the application and I am attaching it here...please let me know any possible wayout..what I am going to do soon is concatenate as many tables as possible and then perform calculation sin the scripting...thats the best I could think of ,for now..if you guys get any other suggestions after going through the application please let me know...Thanks..

[Anonymous]

Guys I got the application and I am attaching it here...please let me know any possible wayout..what I am going to do soon is concatenate as many tables as possible and then perform calculation sin the scripting...thats the best I could think of ,for now..if you guys get any other suggestions after going through the application please let me know...Thanks..

[jonas_rezende]

Hi.

See in link below, documents that cover best practice in data model, there are several *.pdf until ppt.

https://community.qlik.com/thread/86988

Hope this help!

[Anonymous]

Can Anybody help me with this?

I want to write a condition as follows-

If(Col A =Col B and Col C= Col D,F)

Col A ,B ,C,D are all from different tables.

How do I achieve this?

[vcanale]

Hi Adheesh,

- Double check the data model and try to optimise it using joins, mapping load..

- You didn't set any variable. Try to store the expressions in variables, and use the same variables wherever you need them, to ensure that the calculations are not repeated. Same for the Calculated Dimensions.

- Use the Date field to filter the data at least by Year (..or Quarter or Month)

Also.. do you really need to show the rows reporting "Missing" for all the fields?

[Anonymous]

Hi Vincenza

Thanks for your suggestion I'll try for variables and as for the date field there is only 2 month data in this report it is working on selections but once I clear the selections it goes out of memory...

[vcanale]

If you remove the 3 Calculated Dimensions:
1) =if(trim(Capitalize([Dist_From City]))=trim(Capitalize([Dist_From City])) and trim(Capitalize([CFA_From City]))=Trim(Capitalize([Ship To Location1])),[Distance in KM])

2) =if(trim(Capitalize([CFA_From City]))=trim(Capitalize([Dist_From City2])) ,Distance2)

3) =round(if([tr_Invoice Date Original]>=[Effective Date] and [tr_Invoice Date Original]<=[Expired Date],[Unit Price]),0.01)

it works!

Add 3 different list box with these 3 formula and have a look at the result!

[Anonymous]

I removed the last dimension yesterday...i Checked it too ..how do I write the first 2 in the script?can u please help me with this?