Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.