Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
kdmarkee
Contributor III

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

Tags (1)
1 Solution

Accepted Solutions

Re: Is stacking expression into defined columns possible with Pivot

Like this?

Capture.PNG

Used a one time macro to hide the second dimension

Pivot Column Width to Zero

4 Replies

Re: Is stacking expression into defined columns possible with Pivot

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

kdmarkee
Contributor III

Re: Is stacking expression into defined columns possible with Pivot

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

Re: Is stacking expression into defined columns possible with Pivot

Like this?

Capture.PNG

Used a one time macro to hide the second dimension

Pivot Column Width to Zero

kdmarkee
Contributor III

Re: Is stacking expression into defined columns possible with Pivot

Thanks you for this; very helpful.

Community Browser