topic Cannot Create a Pivot Table Object in QlikView

Cannot Create a Pivot Table Object

Fri, 27 Apr 2012 17:01:33 GMT

Hi Forum, I am trying to create a Pivot Table Object and i am getting only the fist Dimension and nothing else. I compared it with another Pivot Table that i've created and they look the Same works and the othme except that one works and the other one doesn't. Any Ideas?

Cannot Create a Pivot Table Object

nilesh_gangurde — Fri, 27 Apr 2012 17:12:29 GMT

Hi mroman,

Confirm that u have added the dimensions, expressions in the Chart.

Or attach the qvw file.

Regards,

Nilesh Gangurde

Cannot Create a Pivot Table Object

Fri, 27 Apr 2012 17:15:10 GMT

what expression are you using?

Re: Cannot Create a Pivot Table Object

Fri, 27 Apr 2012 17:25:09 GMT

I am using Adventure Works DW database.I'll attach the QVW file.

Manuel

Re: Cannot Create a Pivot Table Object

Fri, 27 Apr 2012 17:56:09 GMT

Sum(Extended Amount). I am using 2 dimensions and the amount.

Re: Cannot Create a Pivot Table Object

Fri, 27 Apr 2012 17:59:32 GMT

did you get any errors reloading the QVW?

Cannot Create a Pivot Table Object

Fri, 27 Apr 2012 18:20:03 GMT

no, no errors. i can create a table and works fine

Re: Cannot Create a Pivot Table Object

mphekin12 — Fri, 27 Apr 2012 18:29:38 GMT

Go to the Presentation tab of the Chart Properties, uncheck Suppress Zero-Values. All of your Sales Territory Groups will be displayed, but the sum of the Extended Amount for these territories are all $0.00. You might want to try to remove some of the synthetic keys in your data model. That might be the reason why the Extended Amounts are showing up as $0.00.

I hope this helps.

Re: Cannot Create a Pivot Table Object

Fri, 27 Apr 2012 22:41:59 GMT

Thanks,i now know what i am doing wrong.... thanks for the help.