Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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().
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().