Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
kdmarkee
Specialist
Specialist

Is stacking expression into defined columns possible with Pivot

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.

stacked expressions.PNG

1 Solution

Accepted Solutions
sunny_talwar

Like this?

Capture.PNG

Used a one time macro to hide the second dimension

Pivot Column Width to Zero

View solution in original post

4 Replies
sunny_talwar

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

kdmarkee
Specialist
Specialist
Author

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.

non stacked example.PNG

stacked example.PNG

sunny_talwar

Like this?

Capture.PNG

Used a one time macro to hide the second dimension

Pivot Column Width to Zero

kdmarkee
Specialist
Specialist
Author

Thanks you for this; very helpful.