topic Re: Pivot layout problem in QlikView

Pivot layout problem

Wed, 20 May 2015 20:25:27 GMT

I am trying to get my pivot table layout to show months horizontally, but for some reason it moves all dimensions horizontally. Please see attached picture for examples. It works on my other pivot tables, and all properties seem to match. Any ideas?

it will not budge.

Re: Pivot layout problem

JonnyPoole — Wed, 20 May 2015 20:28:39 GMT

Here is a screenshot (in blue) of where to drop the column

also ensure you 'allow pivoting' too on the presentation tab properties

Re: Pivot layout problem

Wed, 20 May 2015 20:35:33 GMT

already done. See below

Re: Pivot layout problem

Wed, 20 May 2015 20:37:40 GMT

for some reason it is defaulting to all horizontal

Re: Pivot layout problem

JonnyPoole — Wed, 20 May 2015 20:48:21 GMT

If you make a basic pivot table (brand new one) do you get the same behavior ?

Re: Pivot layout problem

Wed, 20 May 2015 20:50:42 GMT

I made another (basic) table and it does not. works just fine.

Re: Pivot layout problem

JonnyPoole — Wed, 20 May 2015 20:53:06 GMT

hmm... i don't have an obvious answer. you could try copying the object (duplicating) or systematically remove pieces from it (trial and error). at least the basic software works on your machine... just not 100% sure what could be wrong.

Re: Pivot layout problem

Colin-Albert — Wed, 20 May 2015 21:11:34 GMT

Do you have Indent Mode enabled on the Presentation tab?

Re: Pivot layout problem

Wed, 20 May 2015 21:19:22 GMT

Indent Mode is on the Style tab? No I do not have it selected. i selected it and it did not make a difference.

Re: Pivot layout problem

Colin-Albert — Wed, 20 May 2015 21:25:55 GMT

You are correct- I should have said Style Tab.

Enabling Indent mode does alter dragging and dropping columns on pivot tables or adding /removing columns.

I find it best to turn off indent mode before making any changes and then re-enable it afterwards

Re: Pivot layout problem

qlikviewwizard — Thu, 21 May 2015 04:35:32 GMT

Hi sbeltran,

If you add any new dimension to pivot table format will be changed.

So you have to drag and drop at the columns area.

Again, You have to drag the Month column to end of all the dimensions area to show properly.

Hope it will helpful.