Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

zagzebski
Contributor

Pivot table dimensions vertical instead of horizantal

I am trying to make a pivot table that will put the dimensions in a vertical fashion rather than horizantally. I have seen it before as a way to make an enhanced multibox but whenever I drag the dimensions it obviously just reorders.

I want horitzantal:

Line of Business

Year

Production

I don't want vertical :

Line of Business     Year     Production

Any thoughts?

Steve

Tags (1)
1 Solution

Accepted Solutions

Re: Pivot table dimensions vertical instead of horizantal

Grab the Eau Claire under Branch and drag it to above the 1 at the top

Grab the M3 under Agency and drag it to above where you dropped the Eau Claire

Set the expression to 0.

9 Replies

Re: Pivot table dimensions vertical instead of horizantal

This may be the blog you have seen before.  It certainly provides the answer to your question.

www.qlikfix.com/2014/07/08/building-nicer-dynamic-multibox/

zagzebski
Contributor

Re: Pivot table dimensions vertical instead of horizantal

Actually that is what I was using but it doesn't say how he gets the horizantal view versus the vertical view. I even open the qvw example and can not see how he gets one versus the other. Any thoughts?

Thanks for your response!

Steve

Re: Pivot table dimensions vertical instead of horizantal

Make it a Straight Table.

On Presentation tab make sure Horizontal is unticked

Disable or delete the expression

zagzebski
Contributor

Re: Pivot table dimensions vertical instead of horizantal

Bill - didn't change anything. I still have the fields horizontal...

Line of Business     Year     Production

and not like Barry has in his example:

Line of Business

Year

Production

Re: Pivot table dimensions vertical instead of horizantal

Keep it as a pivot table

Set the expression back to 1

Then drag things to where you want them.

Set the expression back to 0.

zagzebski
Contributor

Re: Pivot table dimensions vertical instead of horizantal

Bill - so below is what I have (as an example). I set the expression to one. I want to move the Agency under the branch but all it does is reorder the columns.

After I try to drag agency under branch

I change the expression to "0" and I get the following (still horizantal not vertical):

Re: Pivot table dimensions vertical instead of horizantal

Grab the Eau Claire under Branch and drag it to above the 1 at the top

Grab the M3 under Agency and drag it to above where you dropped the Eau Claire

Set the expression to 0.

zagzebski
Contributor

Re: Pivot table dimensions vertical instead of horizantal

Awesome! Thanks so much Bill - really appreciate hanging in there with me to get this!

Steve

Re: Pivot table dimensions vertical instead of horizantal

No worries, the Pivot Table drag and drops can be a right pain sometimes.

Community Browser