topic Re: Too many cells in QlikView

Too many cells

Anonymous — Wed, 15 Apr 2015 06:03:42 GMT

Hi i have a container object in which have a pivot table when i reload application it is throwing Too Many Cells and it is not displaying data .How to resolve the issue

Thanks

Re: Too many cells

robert_mika — Wed, 15 Apr 2015 08:21:23 GMT

What's is the size of your data?

Are you using many different colours/formatting in your calculations?

Re: Too many cells

Anonymous — Wed, 15 Apr 2015 08:56:08 GMT

Hi Robert Mika ,

I am not using different colours .

Thanks

Re: Too many cells

awhitfield — Wed, 15 Apr 2015 11:11:48 GMT

Do you still get the error if the pivot is not in the container object?

Andy

Re: Too many cells

Anonymous — Thu, 16 Apr 2015 06:10:58 GMT

Yes Andy ,

i just tried pivot table out of the container object and i am facing the same error .

Re: Too many cells

robert_mika — Thu, 16 Apr 2015 06:22:48 GMT

Could you attached your app to see if this is related to your Qlik or this is happening elsewhere?

Re: Too many cells

Anonymous — Thu, 16 Apr 2015 11:12:23 GMT

Hi Robert ,

Thanks for reply .

I am not authorized to share my app. Its a security issue here.

Generally ,what causes this error?

Thanks

Re: Too many cells

robert_mika — Thu, 16 Apr 2015 11:34:50 GMT

Similar error in Excel is cause by to many cells format.

Maybe it be as well memory or your data model...

What's the size of file/?can you share PrintScreen with the error

Re: Too many cells

Anonymous — Thu, 16 Apr 2015 11:56:29 GMT

Hi Robert ,

I am attaching my application screenshot .please have a look .

Above pic is the container object with three pivot tables. I can see remaining tables data . Only for the first table i couldn't view the data .

Thanks

Re: Too many cells

robert_mika — Thu, 16 Apr 2015 12:29:47 GMT

How large is your data set within container.

It looks like this object can not handle your data set.

Have you tried to reduce the data?

Re: Too many cells

Anonymous — Thu, 16 Apr 2015 13:00:53 GMT

It consists of million records .

Could you please tell me how to reduce the data .

If i missed reducing data , i will do it .

Thanks

Re: Too many cells

robert_mika — Thu, 16 Apr 2015 13:21:12 GMT

You can limit your data load by using FIRST

to example

Table1:

First 1000

Load .....

Look at this topic to see more tips:

Large amount of data (120 million rows) ... anyone got experience?