topic Re: Is stacking expression into defined columns possible with Pivot in QlikView

Is stacking expression into defined columns possible with Pivot

kdmarkee — Tue, 14 Mar 2017 17:54:54 GMT

Is it possible to stack several expression into defined columns in a pivot table, like this, and if so how? Or is there another way to achieve this very unique look. I would be looking to do a month dimension down the left and then creating a column for a set of 3 expressions, so for example if I have 12 expressions to show, I would want to create 4 columns (each with 3 expressions in them). (The expressions will be using set analysis, so I don't think creating a table in script is an option.)

Thanks.

Re: Is stacking expression into defined columns possible with Pivot

sunny_talwar — Tue, 14 Mar 2017 17:55:57 GMT

Would you be able to share some sample data and the output you expect to see from it?

Re: Is stacking expression into defined columns possible with Pivot

kdmarkee — Tue, 14 Mar 2017 19:01:01 GMT

This first image is of a simple pivot table in QlikView...a 1 dimension and 4 expression example.

The second image is the layout being asked of me (just showing the first 2 months of course), which I have never seen done in QlikView before and am wondering if it is possible somehow. Thanks.

Re: Is stacking expression into defined columns possible with Pivot

sunny_talwar — Tue, 14 Mar 2017 19:10:37 GMT

Like this?

Used a one time macro to hide the second dimension

Pivot Column Width to Zero

Re: Is stacking expression into defined columns possible with Pivot

kdmarkee — Tue, 14 Mar 2017 19:54:40 GMT

Thanks you for this; very helpful.