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]

For this , you need to open separate discussion.

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?

For original qtn.. Have you checked your all the tables are associated or not (which you used in expression)

This issue comes when we are using fields from different tables and tables are not associated.

Thank

BKC

[vcanale]

If I am not wrong these fields used in the first formula come from the tables CFA_Master, Distance2 and some other table containing [Dist_From City]..

Try to join or concatenate the tables involved and add the formula in the load statement as an ordinary field..

eg:

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]) as [Any Name You Prefer For This Dimension]

Once you join or concatenate the tables I don't think you will still need the first "if" (- if(trim(Capitalize([Dist_From City]))=trim(Capitalize([Dist_From City])) - )

[Anonymous]

Vincenza ,Thats exactly what I am trying to do..no luck yet...:/

[vcanale]

which are exactly the tables involved in the 2 formulas?.. or send me the script with the concatenation.. I'll try to help

[Anonymous]

for the first condition the table involved would be

Item Master(Dist_From City)

Distance Master(Dist_From City)

CFA Master(CFA_From_City)

Distance2(Dist_From_City)

if u get it let me know meanwhile I am trying my best.

Thanks

[vcanale]

Hi Adheesh,

Unfortunately I don't have the files to reload and test it properly..

Please find attached the file, have a look at the second tab in the editor, reload and check if it works.

Note: I only changed the script.. nothing in the template so the Calculated Dimensions that prevent to see the data are still there.. once reloaded, try to change those Dimensions

[qlikviewwizard]

Hi Document Analyzer 1.14

Will surely help you.

[Anonymous]

Hi Vincenza,

I Tested your application ,got a circular loop...working on it...will keep u posted..thanks for ur help..really appreciate it...