topic Inverted Pivot table in QlikView

Inverted Pivot table

Tue, 01 Mar 2016 17:49:26 GMT

Hi all, I have a slightly odd requirement and hoping someone can suggest a sensible approach.

Essentially I have a fact table with random measures in it and your standard Dimension tables, like Company.

I have a requirement whereby the users want to view a comparison of measures by Company however the Company has to go along the columns and the measures in rows, can anyone please suggest a way of achieving this.

Many thanks in advance!

Re: Inverted Pivot table

swuehl — Tue, 01 Mar 2016 18:55:56 GMT

Shouldn't this just be possible using a standard pivot table chart with dimensions / expressions pivoted as needed?

Have you tried with a pivot table with dimension like File Month and Company and your expressions, then pivot / drag &drop the Company dimension to the top and your expressions to the left?

Re: Inverted Pivot table

Tue, 01 Mar 2016 20:34:44 GMT

Yep you are correct, sorry just me being stupid, when I tried it I wasn't pulling it to the left far enough, I though it had same limitation as Excel, tried it again and it works fine.

Thanks again!