Error while opening straight table.

[#1]

Hi,

I have one qvw in live folder with size 213MB when I am opening straight table it is showing below error.

Cpuld anyone ket me know what it means and how can I solve this please help me.

Thanks.

[bbi_mba_76]

Hi,

you could try to minimize the table, make same selections and then maximize the table.

[#3]

Thanks and how to do that one please any screen shot and if I make this qvw in access point will it show again same problem?

[datanibbler]

Hi Amelia,

you're out of memory, meaning your table uses up way too much resources.

Do you have that same problem with any other objects or only with this table?

=> I had a similar problem and I solved it by reducing the nr. of dimensions for that table:

- Before, I had entered every field I wanted to see as a dimension

=> I tested out how many dimensions I needed to uniquely identify an item (3 or 4) and used just those and entered
     the remainder of fields as formulas. That greatly reduces resource_usage as QlikView doesn't perform all that
     unnecessary searching for differences...

HTH

Best regards,

DataNibbler

[#5]

Hi,

while opening other sheets it is showing same any solution please.

I have one sheet with 3 huge staright tables and two huge table boxes. can I split the straight tables in one sheet and table boxes in another sheet.will this solve my problem?

[datanibbler]

Well, then it seems like you have a more general problem - is your PC powerful enough to deal with QlikView?

[bbi_mba_76]

In the straight tables you have calculated dimensions?

[#8]

Hi Amelia,

This error comes when there is not enough RAM to process input. This can be solved by reducing the number of input records. So try loading script with less input data.

[#9]

Yes there are some calculated dimensions

[#10]

Thanks and I need to make all the columns and at the starting itself I make less input data. any solution please?