topic Limitations of Straight Table in QlikView

Limitations of Straight Table

arieidel — Thu, 23 Jun 2011 15:29:09 GMT

Hi,

I've created a Straight Table with around 40 columns. 5 of them are Dimensions and the rest simple Expressions (like Sum, Count or a String Value).

It's been impossible to list more than 200,000 files in that table because the app crashes (the table stays loading forever...).

Do I have any alternative to solve this problem? All I need is to list many columns x many many rows.

Thanks in advance!

Ariel

Limitations of Straight Table

erichshiino — Wed, 29 Jun 2011 01:18:40 GMT

Do you get a virtual memory error?

Limitations of Straight Table

Wed, 29 Jun 2011 02:39:03 GMT

I would need to agree with Erich that it sounds like a system limitation more than a software limitation. Is there a specific reason you need to be able to look at 8+ million data points simultaneously?.

I'd suggest hitting ctrl-alt-del and fire up the task manager while you are loading the view & see how your resources are doing, namely RAM.

Re: Limitations of Straight Table

arieidel — Wed, 29 Jun 2011 13:11:54 GMT

There is no “rational” reason to look at so many records at the same time. It was just a requirement from a user.

I don’t get an Overflow Memory Error. It is the table that never finishes loading data.

A workaround was setting a Calculation Condition to limit the volume of data to visualize.

I was just wondering whether you found another workaround to avoid this problem.

Re: Limitations of Straight Table

Anonymous — Wed, 29 Jun 2011 22:42:25 GMT

I agree with Leonard. There's probably a good way to redesign this to make it more useful instead of trying to show a 40 x 200.000 matrix. It doesn't sound very useful from a business user perspective.