topic Re: Why does a pivot table have a big X and refresh button? in QlikView

Why does a pivot table have a big X and refresh button?

sarahplymale — Mon, 18 Aug 2014 18:41:18 GMT

In trying to manipulate pivot tables (in one case to swap the rows and columns) I occasionally get a a big grey X through the middle and a little refresh button and what I was trying to do doesn't work. What am I missing here about the table and what is allowed and not.

Thanks!

Re: Why does a pivot table have a big X and refresh button?

amit_saini — Mon, 18 Aug 2014 18:46:29 GMT

Sarah,

Looks like something is wrong in your expression, please check.

Thanks,

Re: Why does a pivot table have a big X and refresh button?

sarahplymale — Mon, 18 Aug 2014 18:48:00 GMT

Then why would it be okay until I try to swap the rows and columns?

Re: Why does a pivot table have a big X and refresh button?

rwunderlich — Mon, 18 Aug 2014 18:56:57 GMT

Can you post a screenshot of the table? (Before the problem).

-Rob

Re: Why does a pivot table have a big X and refresh button?

amit_saini — Mon, 18 Aug 2014 19:01:41 GMT

May be Swaping of rows and columns won't show you desired results.

Thanks,
AS

Re: Why does a pivot table have a big X and refresh button?

sarahplymale — Mon, 18 Aug 2014 19:27:44 GMT

Here is a shot of the table. I have month as the dimension and the current and prior FY as expressions, but I would prefer to swap the rows and colums. Ultimately I want to calculate the % difference from prior year (as an expression), but would visually like that to appear as a row.

Re: Why does a pivot table have a big X and refresh button?

alematex — Mon, 18 Aug 2014 20:50:58 GMT

This ussually happens when your trying to show a lot of data or your expression gets slows because using many conditions.

Try to do the calculus in the script and not in the tables.

Re: Why does a pivot table have a big X and refresh button?

rwunderlich — Mon, 18 Aug 2014 21:57:20 GMT

I'm not sure if you can get what you want from a Pivot table, but you can with a Straight Table. Change the type to Straight Table and check "Horizontal" on the Presentation tab.

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Why does a pivot table have a big X and refresh button?

ashfaq_haseeb — Tue, 19 Aug 2014 07:12:10 GMT

Hi,

It may happens due to low ram.

I wonder do you have enough ram?

Regards

ASHFAQ

Re: Why does a pivot table have a big X and refresh button?

sarahplymale — Tue, 19 Aug 2014 12:09:47 GMT

That does exactly what I wanted! Thanks so much!!