topic error when collapsing pivot table in QlikView

error when collapsing pivot table

skoppe — Wed, 02 Feb 2011 10:21:24 GMT

Hi all,

I have a pivot table:

When I try to collapse all from first dimension (Counterparty), I get an error:

However, when I collapse all in two steps (first from dimension Day and than from dimension Counterparty) it does work.

I use QV Server 10 initial release. I tested the same application on a QV9 server and there it works without a problem.

Anyone knows if this is a bug? Other ideas?

Regards Stefan

Wed, 02 Feb 2011 10:27:42 GMT

Please load ur application.

Wed, 02 Feb 2011 10:33:11 GMT

Hi Stefan,

It may be due to memory issue or with the expression.

skoppe — Wed, 02 Feb 2011 10:35:00 GMT

Unfortunately I'm not allowed to load the application.

skoppe — Wed, 02 Feb 2011 10:36:09 GMT

I have enough memory, on the QV 9 server it works. The QV 9 server has only 4 GB RAM, the QV 10 server 16 GB.

Wed, 02 Feb 2011 10:40:38 GMT

Its k... think problem in ur expresion check your exp.

skoppe — Wed, 02 Feb 2011 14:30:14 GMT

I use very simple expressions:

sum

(Settlement.DealVolume)

avg

(Settlement.ContractPrice)

avg

(Settlement.ClosingPrice)

sum(Settlement.Settlement)

As I mentioned before, it does work on QV 9.

Thanks for the replies!

suniljain — Wed, 02 Feb 2011 14:41:59 GMT

I faced the same problem with QV 10 SR1. same chart works fine in QV 9 SR6 but not in QV 10 SR1.

pls take help of QV Support for whether its bug in QV 10 SR1 or anything else.