Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
aknabe1
Contributor II
Contributor II

Custom side by side columns Pivot Table

I am looking to create a pivot table with values as the rows (measures) and have 3 columns side by side opposed to stacked on top of each other (first image). My goal to build a table in qlik with multiple measures (rows) and have the 3 columns in the first image. I already have the fiscal year/quarters logic, just looking to build out the table

I have been able to build out the first image logic for 1 measure in a table using set analysis (third image), but need it to be applied across 10+ measures within 1 table.

aknabe1_0-1672156034409.png

aknabe1_1-1672156111842.png

 

aknabe1_2-1672156350598.png

 

 

1 Solution

Accepted Solutions
Or
MVP
MVP

Assuming the entire list on the left side is meant to be measures, then the three columns would need to be values of a single dimension. You should be able to do this using ValueList().

View solution in original post

1 Reply
Or
MVP
MVP

Assuming the entire list on the left side is meant to be measures, then the three columns would need to be values of a single dimension. You should be able to do this using ValueList().