Skip to main content
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().